Re: [ADMIN] displaying rules

> Hello, > > is there a way to display created rules in psql environment? > > Regards > Nat No \d option. But can get it from pg_rules system view. It contains the definition as well. regards, bhuvaneswaran ---(end of broadcast)--- TIP 5: Have y

[ADMIN] displaying rules

Hello, is there a way to display created rules in psql environment? Regards Nat _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ---(end of broadcast)-

[ADMIN] Where are the current install instructions?

Will someone please provide or point out where current instructions are located for building and installing the database? The instructions at www.postgresql.org do not discuss the additional tar files (postgresql-opt-7.3.2.tar.gz, postgresql-test-7.3.2.tar.gz, postgresql-base-7.3.2.tar.gz, postgre

Re: Followup Re: [ADMIN] Performance question

Is restarting postmaster on a regular basis necessary for performance? - Original Message - From: "Bob Smith" <[EMAIL PROTECTED]> To: "pgsql-admin" <[EMAIL PROTECTED]> Sent: Wednesday, March 05, 2003 2:20 PM Subject: Followup Re: [ADMIN] Performance question > > OK, I seem to have fixe

Followup Re: [ADMIN] Performance question

OK, I seem to have fixed my own problem here again, sorry. I restarted the postmaster, now _all_ queries are about 10x faster, and the first execution on a new connection is no longer significantly slower than the second. The server (and the original postmaster) had been up for: 11:18AM up 1

[ADMIN] Performance question

When I execute a query on a new connection, the performance is many times slower than if the query is repeated. In other words, if I start psql, execute the query, then repeat it immediately, the second time it takes only about 20% as long to execute. Now here's the confusing part, if I exit

[ADMIN] Inquiry From Form [pgsql]

I have postgres running on Red Hat 7.3. I have my max connections set to 512..when i try to set this higher, the service will not start. is 512 the max? also, is there a command i can type in or a tool out there that will let me view active and inactive connections to the database? also, is

[ADMIN] OOT : Two Lonely Days

I've been two days with no information,ask, question or etc from this milist. So, What's Up..?, Did the Admin kicked me out ??, What did I Do..???   Anybody Know what's exactly going on out there..?? Please...,   GOD Bless You All. Yudha Setiawan.VoIP     No.    : 628899911223344

[ADMIN] test message

I seem to be having trouble getting message to the list. Can someone please reply if this message makes it. Thank you, Jodi Kanter   ___Jodi L KanterBioInformatics Database AdministratorUniversity of Virginia(434) 924-2846[EMAIL PROTECTED]      

Re: [ADMIN] Can Any body discuss details of this Query Plan

Sreedhar, You need to run VACUUM on a regular basis in order to have up-to-date database statistics for the PostgreSQL planner. The EXPLAIN command just has an estimation of how many rows will get processed and what the best way should be to execute the query. Without good table statistics this