Re: [ADMIN] Loader

2007-05-25 Thread Marc G. Fournier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sounds like you want to look at the COPY command ... - --On Friday, May 25, 2007 12:14:17 +0530 Khan, Mahmood Ahram [EMAIL PROTECTED] wrote: Is there any Loader in Postgres like SQL Loader? Through which I can load data from flat files like

Re: [ADMIN] Abnormal storage consumption with autovacuum enabled

2007-05-25 Thread Nicola Mauri
What do you have max_fsm_pages set to? Currently, max_fsm_pages=2 Running VACUUM VERBOSE reports: NOTICE: number of page slots needed (237312) exceeds max_fsm_pages (2) HINT: Consider increasing the configuration parameter max_fsm_pages to a value over 237312. Is this measurement

Re: [ADMIN] Abnormal storage consumption with autovacuum enabled

2007-05-25 Thread Tom Lane
Nicola Mauri [EMAIL PROTECTED] writes: What do you have max_fsm_pages set to? Currently, max_fsm_pages=2 Running VACUUM VERBOSE reports: NOTICE: number of page slots needed (237312) exceeds max_fsm_pages (2) HINT: Consider increasing the configuration parameter max_fsm_pages

Re: [ADMIN] Question about HeapTupleHeaderData

2007-05-25 Thread Alvaro Herrera
Federico escribió: Hi, I'm writing some papers about PostgreSQL physical storage and I'm bumping into the HeapTupleHeaderData layout as descripted here http://www.postgresql.org/docs/8.2/static/storage-page-layout.html Reading the source code in src/include/access/htup.h I got a question.

[ADMIN] User DB Access - RESTRICTIONS

2007-05-25 Thread Marsha Ramsey
Hello all, How to make a postgres user have access to only one database, and to set that access as read only? Thanks...Marsha - Get the Yahoo! toolbar and be alerted to new email wherever you're surfing.

[ADMIN] User DB Access - RESTRICTIONS

2007-05-25 Thread Marsha Ramsey
Hello all, How to make a postgres user have access to only one database, and to set that access as read only? Thanks...Marsha - Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. - The fish