[GENERAL] Large Table Performance

2005-10-22 Thread David Busby
List, I've got a problem where I need to make a table that is going to grow by an average of 230,000 records per day. There are only 20 columns in the table, mostly char and integer. It's FK'd in two places to another table for import/export transaction id's and I have a serial primary key an

Re: [GENERAL] [ADMIN] [HACKERS] retrieve statement from catalogs

2003-11-07 Thread David Busby
Can you just use the SQL logging and read that file afterwords? /djb - Original Message - From: "Jaime Casanova" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, November 07, 2003 14:59 Subject: Re: [GENERAL] [ADMIN] [HACKERS] retrieve s

Re: [GENERAL] Table partitioning for maximum speed?

2003-10-10 Thread David Busby
Is this partitioning like the schemas mentioned here: http://www.postgresql.org/docs/current/static/ddl-schemas.html? Would those help and increase performance? /B - Original Message - From: "Jean-Luc Lachance" <[EMAIL PROTECTED]> To: "Vivek Khera" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTEC