Re: [GENERAL] Postgresql over a SAN

At one point I used a SAN with a 380GB postgresql database. There were no issues. Great benefit? We were able to keep a hot standby servers in case the main server went down. In that case we would just shutdown the primary server, and start the standby one. - Ericson Smith W3matter LLC http

Re: [GENERAL] Postmaster processes taking all the CPU

did no know why. Doing a VACUUM VERBOSE showed tens of thousands of records after just a couple of days. VACUUM FULL cleaned that out right quick. You might also want to do a dump and restore as well to prevent transaction wraparound. - Ericson Smith Developer http://www.funadvice.com On 6/8/07, MC

Re: [GENERAL] Postmaster processes taking all the CPU

Have you done a full vacuum and not just a reqular vacuum? - Ericson Smith Developer http://www.funadvice.com On 6/8/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote: On Fri, Jun 08, 2007 at 03:20:28PM -0500, MC Moisei wrote: > > pack of postmaster(4-22) processes ran by postgres use

Re: [GENERAL] why postgresql over other RDBMS

disadvantage dissapears. If there's anything slow in the site, its ruby template rendering, database access generally is 10% or less of total time it takes to generate our most popular pages. Ericson Smith Developer http://www.funadvice.com -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On

Re: [GENERAL] Searching data across tables, some large

Yeah, we've used Tsearch with joins and searches on other fields on the tsearch table no problem. Tsearches are just another part of a WHERE clause. Regards - Ericson Smith Developer http://www.funadvice.com On 5/23/07, Robert Fitzpatrick <[EMAIL PROTECTED]> wrote: Thanks to Rich

Re: [GENERAL] What is "Postgresql Hot"?

backups. http://www.google.com/search?q=postgresql+hot So yeah, I apologize for the confusion. - Ericson Smith Developer http://www.funadvice.com On 5/21/07, Dave Page <[EMAIL PROTECTED]> wrote: Ericson Smith wrote: > I've not been following up on the list for some time now, and

[GENERAL] What is "Postgresql Hot"?

already give us hot backups? Regards - Ericson Smith Developer http://www.funadvice.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

[GENERAL] Postgresql performance on Opteron 8 CPU

ql issues with 8 CPU machines recently. Does anyone have suggestions that could improve performance? -- Warmest regards, Ericson Smith Programmer Did-it Search Marketing Raise Your Expectations... --- http://www.did-it.com 55 Maple Avenue, 3rd Floor Rockville Center, NY 11570 P: 800.932.77

[GENERAL] Process list in PostgreSQL 8.0

: iacm didit 216.187.113.89(41860) idle 11864 ? R 0:09 postgres: iacm didit 216.187.113.89(41861) INSERT 11906 ? S 0:00 postgres: iacm didit 24.189.251.57(49023) idle Just wondering what the values in parenthesis are and how can we use 'em. -- Warmest regards, Ericson Smith Programmer Did-it S

[GENERAL] XID Data Types

Hello everyone, Take the query below: select *,xmin from settings where xmin > '187167023'::xid limit 5; Although the docs say this is a 32 bit datatype, I have casted the integer '187167023' also to an xid type, but it seems that there is no operator to do a comparison, since I get this error:

Re: [GENERAL] Large DB

gards, Ericson Smith Tracking Specialist/DBA +---+-+ | http://www.did-it.com | "When you have to shoot, shoot, | | [EMAIL PROTECTED] | don't talk! - Tuco |

Re: [GENERAL] Large DB

otta think about what your response times will be in another month based on your growth now. Can your schema stand it then? - Ericson Smith Mooney, Ryan wrote: Hello, I have a single table that just went over 234GB in size with about 290M+ rows. I think that I'm starting to approach so

Re: [GENERAL] Wich hardware suits best for large full-text indexed

Look into running Swish-e instead: http://www.swish-e.org Great speed, nice engine, excellent boolean searches. We run it on several sites each with over 500,000 documents. Performance is consistently sub-second response time, and we also integrate it within PHP, Perl and Postgresql too. I know

Re: [GENERAL] postgresql + apache under heavy load

the database. The drawback is that connections are built up and torn down all the time, and with Postgresql, it is sort of expensive. But thats a fraction of the expense of having KeepAlive on. Warmest regards, Ericson Smith Tracking Specialist/DBA

Re: [GENERAL] Is my MySQL Gaining ?

eeds to move to the next level folks. Now let me get back to migrating to 7.4 :-) Warmest regards, Ericson Smith Tracking Specialist/DBA +---++ | http://www.did-it.com | "When I'm paid, I always | | [EMAIL PROTECTED] | follow the j

Re: [GENERAL] Is my MySQL Gaining ?

sor features of the system and so on. All this is more than a website. Someone posted pictures of the PG booth at a show recently. It was nice, but there was this one sad guy shrouded in darkness -- I felt depressed, because that's how PG advocacy felt. Warm regards, Er

Re: [GENERAL] [ANNOUNCE] PostgreSQL v7.4 Release Candidate 2

Is the some kind of document available that outlines the changes between ver 7.3 and ver 7.4 Best regards, Ericson Smith Web Developer +---+---+ | http://www.did-it.com | Money lost, little lost. | | [EMAIL PROTECTED] | Honor lost, much lost