[GENERAL] Different results from view and from its defintion query [w/ windowing function]

2012-08-19 Thread Thalis Kalfigkopoulos
Sorry for the lack of a more appropriate title. The summary of my problem is: i run a query and I get some results; then I create a view using this query, and I run the same query on the view, and get different results. Details follow. On the original table the analytical data is as follows: # SEL

Re: [GENERAL] Schemas vs partitioning vs multiple databases for archiving

2012-08-19 Thread Gavin Flower
On 19/08/12 17:50, Chris Travers wrote: On Sat, Aug 18, 2012 at 9:30 PM, Gavin Flower mailto:gavinflo...@archidevsys.co.nz>> wrote: On 18/08/12 20:05, Bartel Viljoen wrote: [...] I’m in the design faze of a new GUI and DB layout, what are my options. [...] I thin

Re: [GENERAL] importing updated files into a database

2012-08-19 Thread Craig Ringer
On 08/19/2012 10:49 PM, fashouri wrote: I have files that are updated every 2 hours. I have to detect the files automatically and insert the information from them into a database. The files are simple text files and I know which part of them is useful for me. Our DBMS is Postgresql and programmin

[GENERAL] importing updated files into a database

2012-08-19 Thread fashouri
I have files that are updated every 2 hours. I have to detect the files automatically and insert the information from them into a database. The files are simple text files and I know which part of them is useful for me. Our DBMS is Postgresql and programming language is python. what is your suggest

Re: [GENERAL] How hard would a "path" operator be to implement in PostgreSQL

2012-08-19 Thread Chris Travers
Hi David; On Sun, Aug 19, 2012 at 8:13 PM, David Johnston wrote: > On Aug 19, 2012, at 21:28, Chris Travers wrote: > > > Hi; > > > > I have been reading up on object-relational features of Oracle and DB2 > and found that one of the big things they have that we don't is a path > operator. The i

Re: [GENERAL] How hard would a "path" operator be to implement in PostgreSQL

2012-08-19 Thread Craig Ringer
On 08/20/2012 11:13 AM, David Johnston wrote: On Aug 19, 2012, at 21:28, Chris Travers wrote: Hi; I have been reading up on object-relational features of Oracle and DB2 and found that one of the big things they have that we don't is a path operator. The idea is that you can use the path op

Re: [GENERAL] Ignore hash indices on replicas

2012-08-19 Thread Scott Marlowe
On Tue, Jul 10, 2012 at 1:09 AM, Steven Schlansker wrote: > I'm using Postgres hash indices on a streaming replica master. > As is documented, hash indices are not logged, so the replica does not have > access to them. > > I understand that the current wisdom is "don't use hash indices", but > (

Re: [GENERAL] How hard would a "path" operator be to implement in PostgreSQL

2012-08-19 Thread David Johnston
On Aug 19, 2012, at 21:28, Chris Travers wrote: > Hi; > > I have been reading up on object-relational features of Oracle and DB2 and > found that one of the big things they have that we don't is a path operator. > The idea is that you can use the path operator to follow some subset of > fore

[GENERAL] citext: citext=text is case sensitive

2012-08-19 Thread Craig Ringer
Hi all While looking into a Stack Overflow question, I noticed that the comparision of citext = text is case sensitive. While I'm sure that's by design, it isn't obvious in the documentation, and it was a little surprising to me. It's particularly confusing when combined with prepared statem

Re: [GENERAL] How hard would a "path" operator be to implement in PostgreSQL

2012-08-19 Thread Ondrej Ivanič
Hi, On 20 August 2012 11:28, Chris Travers wrote: > I have been reading up on object-relational features of Oracle and DB2 and > found that one of the big things they have that we don't is a path operator. > The idea is that you can use the path operator to follow some subset of > foreign keys ca

[GENERAL] How hard would a "path" operator be to implement in PostgreSQL

2012-08-19 Thread Chris Travers
Hi; I have been reading up on object-relational features of Oracle and DB2 and found that one of the big things they have that we don't is a path operator. The idea is that you can use the path operator to follow some subset of foreign keys called refs. Suppose we have a table (Oracle/DB2 styles

Re: [GENERAL] Ignore hash indices on replicas

2012-08-19 Thread Jeff Davis
On Tue, 2012-07-10 at 00:09 -0700, Steven Schlansker wrote: > I understand that the current wisdom is "don't use hash indices", but > (unfortunately?) I have benchmarks that > show that our particular application is faster by quite a bit when a > hash index is available. Can you publish the result

[GENERAL] xml performance

2012-08-19 Thread Raju Angani
Hi, I have been looking into Postgres for last 1 month. I was wondering if there is a easy wy to store xml data in Postgres and not have any performance impact. Few properties of the XML doc that are stored in the table 1) Each doc could be 1mb in size. 2) Need to update few attributes with the

Re: [GENERAL] Views versus user-defined functions: formatting, comments, performance, etc.

2012-08-19 Thread Dmitriy Igrishin
2012/8/18 Merlin Moncure > On Fri, Aug 17, 2012 at 5:44 PM, Tom Lane wrote: > > Adam Mackler writes: > >> I notice when I save a view, I lose all the formatting and comments. > >> As I was writing a complicated view, wanting to retain the format and > >> comments, I thought I could just save it