[ADMIN] SET search path

Hi, I am using postgresql 8.4.0 Select version() gives: PostgreSQL 8.4.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-10), 64-bit I have trying to set search path, so that I do not have to append the schema_name while doing a select on the tables, howev

Re: [ADMIN] SET search path

Στις Sunday 30 October 2011 12:34:38 ο/η Akash Kodibail έγραψε: > Hi, > > I am using postgresql 8.4.0 > > Select version() gives: > > PostgreSQL 8.4.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 > 20060404 (Red Hat 3.4.6-10), 64-bit > > I have trying to set search path, so tha

[ADMIN] My Query to insert and retrieve takes time

Hi Community, Require some help, I am running postgres 9.1 database, which has table having around 300,000 records, my problem is that it takes 8.314 milliseconds to update one record, and the below is the explain PLAN of (terminal_id is UNIQUE index, and term_index is primary key) EXPLAIN ANAL

[ADMIN] Shivakumar Ramannavar has invited you to open a Google mail account

I've been using Gmail and thought you might like to try it out. Here's an invitation to create an account. You're Invited to Gmail! Shivakumar Ramannavar has invited you to open a Gmail account. Gmail is Google's free email service, built on the idea that email can be intuitive, efficient, an

Re: [ADMIN] My Query to insert and retrieve takes time

Shivakumar Ramannavar wrote: > my problem is that it takes 8.314 milliseconds to update one > record > EXPLAIN ANALYZE UPDATE terminal > Update ... actual time=0.074..0.074 If you look at the EXPLAIN ANALYZE of the UPDATE, you'll see that the UPDATE itself actually took only a small fra

Re: [ADMIN] SET search path

Achilleas Mantzios wrote: > Sunday 30 October 2011 12:34:38 */* Akash Kodibail **: >> I am using postgresql 8.4.0 Please consider an immediate update to 8.4.9. http://www.postgresql.org/support/versioning >> I have trying to set search path >> the search_path is set only for tha

Re: [ADMIN] SET search path

In article <201110311014.45633.ach...@matrix.gatewaynet.com>, Achilleas Mantzios writes: > Στις Sunday 30 October 2011 12:34:38 ο/η Akash Kodibail έγραψε: >> Hi, >> >> I am using postgresql 8.4.0 >> >> Select version() gives: >> >> PostgreSQL 8.4.0 on x86_64-unknown-linux-gnu, compiled by GCC

[ADMIN] Corruption Debug Help.

Hi All, I believe I may have experienced a Postgres bug and am eager for bit of feedback. It seems we may have had some type of catalog corruption as overview in the events pasted below. I am including our observations of the problem, but am asking the list to see if I can perform any further di

[ADMIN] background writer being lazy?

Hi all, I have a large database that I'm trying to do some buffer writer tuning to. I have a data collector set up on pg_stat_bgwriter so I can see the statistics over time, and see how many buffers are being written by checkpoints, and how many are being written by the background writer. Th