Re: [PERFORM] Thousands of tables versus on table?

2007-06-05 Thread Thomas Andrews
hen our off hours are.) =thomas On 6/5/07 12:48 PM, "Scott Marlowe" <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: >> On Mon, 4 Jun 2007, Scott Marlowe wrote: >> >>> Gregory Stark wrote: >>>> "Thomas Andrews" <[EMAIL PROTECT

Re: [PERFORM] Thousands of tables versus on table?

2007-06-04 Thread Thomas Andrews
Linux 2.4.9, if I¹m reading this right. =thomas On 6/4/07 4:08 PM, "Y Sidhu" <[EMAIL PROTECTED]> wrote: > On 6/4/07, Thomas Andrews <[EMAIL PROTECTED]> wrote: >> >> >> >> On 6/4/07 3:43 PM, "Gregory Stark" <[EMAIL PROTECTE

Re: [PERFORM] Thousands of tables versus on table?

2007-06-04 Thread Thomas Andrews
On 6/4/07 3:43 PM, "Gregory Stark" <[EMAIL PROTECTED]> wrote: > > "Thomas Andrews" <[EMAIL PROTECTED]> writes: > >> I guess my real question is, does it ever make sense to create thousands of >> tables like this? > > Sometimes. But

Re: [PERFORM] Thousands of tables versus on table?

2007-06-04 Thread Thomas Andrews
Mark Lewis wrote: On Mon, 2007-06-04 at 13:40 -0400, Thomas Andrews wrote: I have several thousand clients. Our clients do surveys, and each survey has two tables for the client data, responders responses Frequent inserts into both table. Right now, we are seeing significant time d

Re: [PERFORM] Thousands of tables versus on table?

2007-06-04 Thread Thomas Andrews
Oh, and we vacuum every day. Not sure about REINDEX, but I doubt we have done that. =thomas Mark Lewis wrote: On Mon, 2007-06-04 at 13:40 -0400, Thomas Andrews wrote: I have several thousand clients. Our clients do surveys, and each survey has two tables for the client data, responders

[PERFORM] Thousands of tables versus on table?

2007-06-04 Thread Thomas Andrews
I have several thousand clients. Our clients do surveys, and each survey has two tables for the client data, responders responses Frequent inserts into both table. Right now, we are seeing significant time during inserts to these two tables. Some of the indices in tableA and tableB do no