PostGreSQL setup/complexity

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #20,145 by broomberg 12/3/01 8:18:29 PM Reply	PostGreSQL setup/complexity I was wrong, or it has gotten a lot better. Took the RPMs, followed the docs, and had the large table loading in about 10 minutes.
Post #20,150 by admin 12/3/01 8:58:00 PM Reply	Yep. I like Postgres a lot. I know it's not anywhere near what you'll be doing, but we've had nary a skip here on zIWT from the postgres stuff (once I decided to start vacuuming the database every once in a while :-). Regards, -scott anderson
Post #20,156 by broomberg 12/3/01 9:42:28 PM Reply	Re: Yep. I'm on my 1st vacuum after creating 6 indexes. How long should it take?
Post #20,166 by admin 12/3/01 11:07:27 PM Reply	Shouldn't need one right away. It's for recalculating index distributions and the like. Kind of a waste right after indexing... :-) I wouldn't know how long that much data would take. The zIWT tables aren't all that large yet. Regards, -scott anderson

MySQL vs Oracle question - (broomberg) - (23) - Dec. 2, 2001, 09:37:16 AM EST

Other things to consider: - (admin) - (14) - Dec. 2, 2001, 11:45:06 AM EST

Re: Other things to consider: - (broomberg) - (6) - Dec. 2, 2001, 12:08:04 PM EST

Interbase "seen" as going away... - (admin) - (5) - Dec. 2, 2001, 03:34:21 PM EST

Re: Interbase "seen" as going away... - (broomberg) - Dec. 2, 2001, 07:41:07 PM EST

PostGreSQL setup/complexity - (broomberg) - (3) - Dec. 3, 2001, 08:18:29 PM EST

Yep. - (admin) - (2) - Dec. 3, 2001, 08:58:00 PM EST

Re: Yep. - (broomberg) - (1) - Dec. 3, 2001, 09:42:28 PM EST

Shouldn't need one right away. - (admin) - Dec. 3, 2001, 11:07:27 PM EST

Wierd create index behaviour - (broomberg) - (6) - Dec. 2, 2001, 12:36:13 PM EST

index create - (boxley) - (5) - Dec. 2, 2001, 08:04:05 PM EST

Re: index create - (broomberg) - (4) - Dec. 2, 2001, 09:09:04 PM EST

Well, Sybase still has some money - (tonytib) - Dec. 2, 2001, 09:39:52 PM EST

Re: index create - (broomberg) - (2) - Dec. 2, 2001, 10:27:47 PM EST

1.5 hours to create index - (broomberg) - Dec. 2, 2001, 10:53:57 PM EST

That's why I'd second the Interbase recommendation - (tseliot) - Dec. 3, 2001, 03:28:05 PM EST

Re: MySQL vs Oracle question - (wharris2) - (2) - Dec. 3, 2001, 12:47:34 AM EST

Readonly - (broomberg) - (1) - Dec. 3, 2001, 07:09:48 AM EST

Readonly? Hell, then, full speed ahead! -NT - (wharris2) - Dec. 6, 2001, 07:41:13 PM EST

14 hours later, still indexing - (broomberg) - (2) - Dec. 3, 2001, 02:08:57 PM EST

20 hours later, still indexing - (broomberg) - (1) - Dec. 3, 2001, 08:15:59 PM EST

Wheeee - Done!!! - (broomberg) - Dec. 3, 2001, 11:03:46 PM EST

New design - (broomberg) - (1) - Dec. 5, 2001, 08:58:34 PM EST

Happy Ending! - (Meerkat) - Dec. 6, 2001, 06:01:45 PM EST