Re: [GENERAL] Optimzing Postgresql

On Sat, May 24, 2008 at 11:57 AM, Ram Ravichandran <[EMAIL PROTECTED]> wrote: > ..."High Performance MySQL" ... BTW: The current version of this book is (somewhat) out of date, and the next version will be released in next few months. -- Rob Wultsch [EMAIL PROTECTED] -- Sent via pgsql-general m

[GENERAL] FAQ correction for Windows 2000/XP

I'd like to submit a correction for question "2.1) How do I setup a datasource?" in the FAQ. The existing text reads: "For Windows, use the ODBC Administrator in Control Panel. Here you can add, modify, or delete data sources." On Windows XP, however, there is no Control Panel applet for ODBC man

Re: [GENERAL] Optimzing Postgresql

Steve Atkins wrote: Hang out on the pgsql-performance mailing list and see what other people do - "How do I tune a database for X" comes up pretty regularly, and gets good answers, so trolling through the mailing list archive can give some very good advice. Aside from the hardware and serv

Re: [GENERAL] Copying data from a table to another database

Pedro Doria Meunier wrote: Hi all, This is perhaps a very 'newbie' question but for the life of me, I can't see a way to do it without resorting to programming... (blush) something like - pg_dump --data-only --table=myoldhistorytable | psql -h x.x.x.x mynewdb The thing is: I have a table t

Re: [GENERAL] Copying data from a table to another database

On Sun, 2008-05-25 at 12:24 +0100, Pedro Doria Meunier wrote: > Now I've migrated the entire 'shebang' to another server and need to > update the history table on the new server with data from the old > server > for every different record. I'm not sure I understand this completely. Would COPY wo

Re: [GENERAL] Copying data from a table to another database

You can do this with dblink http://www.postgresql.org/docs/8.3/interactive/contrib-dblink.html pretty easily. Jon > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] On Behalf Of Pedro Doria Meunier > Sent: Sunday, May 25, 2008 6:25 AM > To: Postgres

Re: [GENERAL] Copying data from a table to another database

Pedro Doria Meunier wrote: Hi all, This is perhaps a very 'newbie' question but for the life of me, I can't see a way to do it without resorting to programming... (blush) As far as I'm concerned writing SQL is programming. It's not (usually) procedural, but neither is Prolog, ML, Haskell, or

[GENERAL] Performance Problem - pgsql on MD3000 DAS

Hi All, We're migrating to new hardware and to pgsql 8.3.1 from pgsql 8.2.4. We were scheduled to go live yesterday morning but elected not to late Friday after observing this issue: Our new hardware includes an external Dell MD3000 RAID array of 15 15k SAS disks. We have a 2 disk RAID1 array fo

[GENERAL] Copying data from a table to another database

Hi all, This is perhaps a very 'newbie' question but for the life of me, I can't see a way to do it without resorting to programming... (blush) The thing is: I have a table that acts as a historic for some devices activity. Now I've migrated the entire 'shebang' to another server and need to upda

Re: [GENERAL] best er modeling tool for postgreSQL

jcvlz wrote on 25.05.2008 04:41: /** Not-free **/ Microsoft Visio - (If you already have it, it does work quite well) DataStudio - 30 day trial http://www.aquafold.com DBWrench - 30 day trial http://www.dbwrench.com/ There are some more non-free ones (although Windows only) DeZign: htt