Re: [GENERAL] autoanalyze criteria

On Feb 23, 2013, at 14:11, Stefan Andreatta wrote: > And we are still missing a number for rows updated since the last analyse. In MVCC an update is an insert + delete, so you already got those numbers. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find t

Re: [GENERAL] Dumb question involving to_tsvector and a view

Jasen Betts wrote: >On 2013-02-23, Raymond C. Rodgers wrote: >> On 02/23/2013 05:26 AM, Tom Lane wrote: >>> A "virtual" tsvector like that is probably going to be useless for >>> searching as soon as you get a meaningful amount of data, because the >>> only way the DB can implement a search is t

Re: [GENERAL] [JDBC] can't access through SSL

On Feb 23, 2013, at 11:05 PM, Maz Mohammadi wrote: > > FATAL: connection requires a valid client certificate. I use openssl to verify the chain, I think that would help you know what's going on: openssl verify -CAfile rootca.crt user.crt

Re: [GENERAL] [JDBC] can't access through SSL

On 02/23/2013 08:05 PM, Maz Mohammadi wrote: I still can’t access my SSL enabled server!!! Is root.crt supposed to be an exact copy of server.crt file which I use in my client’s keystore? I have another observation. As I start the coordinator node, I don’t see any file access to the server.key

Re: [GENERAL] [JDBC] can't access through SSL

Correct! I'm new postgresql and I need to figure this out for a client. I installed a bunch packages on my Ubuntu linux and here I am. I've learned a lot. I have 2 datanodes, coordinator + gtm. -maz -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Sun

Re: [GENERAL] [JDBC] can't access through SSL

On 02/24/2013 02:35 PM, Maz Mohammadi wrote: Correct! I'm new postgresql and I need to figure this out for a client. I installed a bunch packages on my Ubuntu linux and here I am. I've learned a lot. I have 2 datanodes, coordinator + gtm. Some general pointers on helping to figure this ou

Re: [GENERAL] [JDBC] can't access through SSL

Hi Adrian, Thanks for sharing some pointers with me. You are right, it's not actually an JDBC driver issue. I posted it on jdbc, because I'm accessing it from a jdbc client, I thought there might be some security issues with the JDBC driver. 1) I'm running postgres-xc v. 9.1. I'm "pretty" su

[GENERAL] Floating point error

Hi Everyone, Riddle me this. I have a database column of type "real" that gets mapped to a Java field of type double via JDBC. We have two databases, test and production, and the test database is periodically blown away and reloaded from a copy of production. We recently noticed that some value

Re: [GENERAL] Floating point error

On 2/24/2013 6:13 PM, Tom Duffey wrote: - The Java app on production shows "10.3884573" while the test app shows "10.3885" 'real' is single precision, which is only about 6 digits of decimal accuracy. if your java variables were double precision, you probably should have used double in pos

Re: [GENERAL] Floating point error

On 2/24/2013 6:20 PM, John R Pierce wrote: On 2/24/2013 6:13 PM, Tom Duffey wrote: - The Java app on production shows "10.3884573" while the test app shows "10.3885" 'real' is single precision, which is only about 6 digits of decimal accuracy. if your java variables were double precision, y

Re: [GENERAL] Floating point error

Em 24/02/2013 23:26, John R Pierce escreveu: On 2/24/2013 6:20 PM, John R Pierce wrote: On 2/24/2013 6:13 PM, Tom Duffey wrote: - The Java app on production shows "10.3884573" while the test app shows "10.3885" 'real' is single precision, which is only about 6 digits of decimal accuracy. i

Re: [GENERAL] Floating point error

On 02/24/2013 06:13 PM, Tom Duffey wrote: Hi Everyone, Riddle me this. I have a database column of type "real" that gets mapped to a Java field of type double via JDBC. We have two databases, test and production, and the test database is periodically blown away and reloaded from a copy of prod

Re: [GENERAL] Floating point error

On Feb 24, 2013, at 8:44 PM, Adrian Klaver wrote: > On 02/24/2013 06:13 PM, Tom Duffey wrote: >> Hi Everyone, >> >> Riddle me this. I have a database column of type "real" that gets mapped to >> a Java field of type double via JDBC. We have two databases, test and >> production, and the test

Re: [GENERAL] Floating point error

Em 24/02/2013 23:44, Adrian Klaver escreveu: On 02/24/2013 06:13 PM, Tom Duffey wrote: Hi Everyone, Riddle me this. I have a database column of type "real" that gets mapped to a Java field of type double via JDBC. We have two databases, test and production, and the test database is periodical

Re: [GENERAL] Floating point error

On 02/24/2013 06:58 PM, Tom Duffey wrote: On Feb 24, 2013, at 8:44 PM, Adrian Klaver wrote: On 02/24/2013 06:13 PM, Tom Duffey wrote: Hi Everyone, Riddle me this. I have a database column of type "real" that gets mapped to a Java field of type double via JDBC. We have two databases, test a

Re: [GENERAL] [JDBC] can't access through SSL

On 02/24/2013 05:54 PM, Maz Mohammadi wrote: Hi Adrian, Thanks for sharing some pointers with me. You are right, it's not actually an JDBC driver issue. I posted it on jdbc, because I'm accessing it from a jdbc client, I thought there might be some security issues with the JDBC driver. 1) I

Re: [GENERAL] [JDBC] can't access through SSL

On Mon, Feb 25, 2013 at 10:07 AM, Adrian Klaver wrote: > 1) Postgres-XC != Postgres. It shares a code base but adds more moving > parts. Along that line, you will need to be more specific about how you > have setup Postgres-XC and exactly which part is failing? I for one do not > use it, so I am n

Re: [GENERAL] autoanalyze criteria

On 02/24/2013 12:52 PM, Alban Hertroys wrote: On Feb 23, 2013, at 14:11, Stefan Andreatta > wrote: And we are still missing a number for rows updated since the last analyse. In MVCC an update is an insert + delete, so you already got those numbers. Good point.