[GENERAL] application for postgres Log

2012-09-09 Thread Arvind Singh
Hello and namaste I am in a project that uses PostGresSql v9.0. We are developing an application in CSharp to parse the PG server activity log installed on Windows 2003/XP or higher. Our application will : Scan the Log for a given search text and Post rows found Produce statistics related t

Re: [GENERAL] How to get faster queries in the database?

2012-09-09 Thread David Johnston
On Sep 9, 2012, at 16:36, Andre Lopes wrote: > Hi, > > I've developed a system that was not to work online, but now it is > online and it is degrading due to bad design choices. > > Here is the thing. I've the database build in "vertical mode". I will > justo explain what I mean with that. > >

[GENERAL] How to get faster queries in the database?

2012-09-09 Thread Andre Lopes
Hi, I've developed a system that was not to work online, but now it is online and it is degrading due to bad design choices. Here is the thing. I've the database build in "vertical mode". I will justo explain what I mean with that. Attribute | Value site_name | Some site name1 uri

[GENERAL] PGDay at FOSDEM - your input is needed!

2012-09-09 Thread Magnus Hagander
We (PostgreSQL Europe) are considering to hold a PGDay on February 1st 2012, the day before FOSDEM, in Brussels, Belgium. This will be one day of PostgreSQL presentations, in addition to the devroom we plan to run during FOSDEM, in order to expand the PostgreSQL presence. It will be a single track

Re: [GENERAL] Add a check an a array column

2012-09-09 Thread Gavin Flower
On 09/09/12 23:12, vdg wrote: Thanks for your help. Before posting, I had tried something like check ((ALL(i) >= 0) AND (ALL(i) <= 1024 ))); but i got syntax errors. It seems the first ALL() was not recognized. Could someone give me documentation hints on this behaviour ? vdg On Saturday,

[GENERAL] good article

2012-09-09 Thread Robert Bernier
http://ledgersmbdev.blogspot.co.uk/2012/09/or-modelling-interlude-postgresql-vs.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] good article

2012-09-09 Thread Robert Bernier
http://ledgersmbdev.blogspot.co.uk/2012/09/or-modelling-interlude-postgresql- vs.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Add a check an a array column

2012-09-09 Thread Tom Lane
vdg writes: > Before posting, I had tried something like > check ((ALL(i) >= 0) AND (ALL(i) <= 1024 ))); > but i got syntax errors. Well, that's not the syntax. > Could someone give me documentation hints on this behaviour ? http://www.postgresql.org/docs/9.1/static/functions-subquery.html#F

Re: [GENERAL] Add a check an a array column

2012-09-09 Thread Andreas Kretschmer
Thomas Kellerer wrote: > Bret Stern wrote on 08.09.2012 22:18: >> A better place for validation is in the front-end, before >> adding/attempting to add data to the db (my opinion). >> Nice to see there are always other ways though. >> > > I beg to differ: every validation that can be enforced by

Re: [GENERAL] Add a check an a array column

2012-09-09 Thread Thomas Kellerer
Bret Stern wrote on 08.09.2012 22:18: A better place for validation is in the front-end, before adding/attempting to add data to the db (my opinion). Nice to see there are always other ways though. I beg to differ: every validation that can be enforced by declarative constraints *should* be c

Re: [GENERAL] Add a check an a array column

2012-09-09 Thread vdg
Thanks for your help. Before posting, I had tried something like check ((ALL(i) >= 0) AND (ALL(i) <= 1024 ))); but i got syntax errors. It seems the first ALL() was not recognized. Could someone give me documentation hints on this behaviour ? vdg On Saturday, 08 September 2012 13:18:25 Bret

Re: [GENERAL] Index creation takes more time?

2012-09-09 Thread Tomas Vondra
Hi, Dne 09.09.2012 11:25, Herouth Maoz napsal: We have tables which we archive and shorten every day. That is - the main table that has daily inserts and updates is kept small, and there is a parallel table with all the old data up to a year ago. In the past we noticed that the bulk transfer

Re: [GENERAL] how to group by similarity ?

2012-09-09 Thread Tim Uckun
On Wed, Apr 25, 2012 at 8:34 PM, wrote: > Andreas writes: > >> How would I group the table so that it shows groups that have >> similarity () > x ? >> >> Lets say the table looks like this: >> >> id, txt >> 1, aa1 >> 2, bb1 >> 3, cc1 >> 4, bb2 >> 5, bb3 >> 6, aa2 >> ... >> >> How wo

[GENERAL] Index creation takes more time?

2012-09-09 Thread Herouth Maoz
We have tables which we archive and shorten every day. That is - the main table that has daily inserts and updates is kept small, and there is a parallel table with all the old data up to a year ago. In the past we noticed that the bulk transfer from the main table to the archive table takes a