[GENERAL] Correct update statement

Hi Please help, we are using postgreSQL 9.2.4. I need to update over 9000 rows. See the query below: A table called contact has got *addr_id *field as null which is incorrect. So now I need to update contact table for each account (cus_acno is in cus table) where contact_addr_id is null. For ex

[GENERAL] are analyze statistics synced with replication?

We have a master/slave setup with replication. Today we failed over to the slave and saw disk I/O go through the roof. Are the pg_statistic statistics synced along with streaming replication? Are you expected to have to do a vacuum analyze after failing over? That's what we're trying now to see

Re: [GENERAL] what should be the best autovacuum configuration for daily partition table

On Wed, May 14, 2014 at 3:45 PM, Jeff Janes wrote: > On Wed, May 14, 2014 at 12:06 AM, AI Rumman wrote: > >> Hi, >> >> I have a table with daily partition setup where old partitions are static >> tables that is after each day we don't get any new data in old partitions. >> The database size is 2

Re: [GENERAL] what should be the best autovacuum configuration for daily partition table

On Wed, May 14, 2014 at 12:06 AM, AI Rumman wrote: > Hi, > > I have a table with daily partition setup where old partitions are static > tables that is after each day we don't get any new data in old partitions. > The database size is 2 TB and I am running with autovacuum on for > Postgresql 8.4.

Re: [GENERAL] what should be the best autovacuum configuration for daily partition table

Hi Rumman, Please publish the below information. 1. vacuum and auto-vacuum parametters current settings on cluster. select name,setting from pg_settings where name ilike '%vacuum%'; 2. show maintenance_work_mem ; show autovacuum_max_workers ; 3. Physical Ram size on server. --Chiru

Re: [GENERAL] LDAP authentication not working

On May 14, 2014 12:56 AM, "Magnus Hagander" wrote: > > On Wed, May 14, 2014 at 11:48 AM, Jürgen Fuchsberger < juergen.fuchsber...@uni-graz.at> wrote: >> >> >> >> On 05/14/2014 09:10 AM, Magnus Hagander wrote: >> > On Wed, May 14, 2014 at 8:35 AM, Stephan Fabel > > > wrote

Re: [GENERAL] Receiving many more rows than expected

On Friday 09 May 2014 08:36:04 David G Johnston wrote: > This seems to likely be the same, still open, bug reported previously: > > No Number Assigned: > http://www.postgresql.org/message-id/CANCipfpfzoYnOz5jj=UZ70_R=CwDHv36dqWSpw > si27vpm1z...@mail.gmail.com > > #8464 > http://www.postgresql.or

Re: [GENERAL] LDAP authentication not working

On Wed, May 14, 2014 at 11:48 AM, Jürgen Fuchsberger < juergen.fuchsber...@uni-graz.at> wrote: > > > On 05/14/2014 09:10 AM, Magnus Hagander wrote: > > On Wed, May 14, 2014 at 8:35 AM, Stephan Fabel > > wrote: > > > > I don't think SSL support for LDAP is supported.

Re: [GENERAL] Log Data Analytics : Confused about the choice of Database

On Wed, May 14, 2014 at 6:48 AM, Peeyush Agarwal < peeyushagarwal1...@gmail.com> wrote: > Hi, > > Thanks for the reply :) > > Yes, Storing timestamp as timestamp [ (p) ] would be better. I simplified > the session in question. It may contain alphabets as well. So, I will > probably need to store i

Re: [GENERAL] Full-Text Search question

Search for fulltext tutorial + json functions http://www.postgresql.org/docs/9.3/static/functions-json.html On Wed, May 14, 2014 at 1:00 AM, Jesus Rafael Sanchez Medrano < jesusraf...@gmail.com> wrote: > thanks... could you please be so kind to post some snippet/code for this? > > Att. > == > J

Re: [GENERAL] better performance on poorer machine?

Hi, all. I found the problem - it was merely a poorly written query, which for some reason was less terrible on my laptop. Looking at http://explain.depesz.com/ helped me solve the issue. Performance is now back to normal. It seems this was a classic case of pebcak. Thank you for your help and

Re: [GENERAL] LDAP authentication not working

On Wed, May 14, 2014 at 8:35 AM, Stephan Fabel wrote: > I don't think SSL support for LDAP is supported. Have you tried TLS on > port 389? > Correct, and you need to set ldaptls=1 to use that as well. (And yes, unfortunately the LDAP error messages from openldap are notoriously bad) //Magnus

[GENERAL] what should be the best autovacuum configuration for daily partition table

Hi, I have a table with daily partition setup where old partitions are static tables that is after each day we don't get any new data in old partitions. The database size is 2 TB and I am running with autovacuum on for Postgresql 8.4. Now, I am facing a problem where old tables are not being vacuu