Re: [GENERAL] Indexes not allowed on (read-only) views: Why?

2011-09-18 Thread Thomas Kellerer
Craig Ringer, 17.09.2011 02:28: On 09/17/2011 05:47 AM, Stefan Keller wrote: A (read-only) view should behave like a table, right? CREATE INDEX t1_idx ON t1 (rem); ERROR: »v1« not a table SQL state: 42809 => Why should'nt it be possible to create indexes on views in PG? It's not so much th

Re: [GENERAL] duplicate sequence, it is possible?

2011-09-18 Thread Alban Hertroys
On 19 Sep 2011, at 2:57, Anibal David Acosta wrote: > Hi everyone. > > I have a table with a PK, this table has a lot of insert per second (100 ~ > 150 insert /sec) > Sometimes, a get a duplicate key error, but ID is generated from a function > (VOLATILE). This function has just one line (sele

Re: [GENERAL] index row requires 10040 bytes, maximum size is 8191

2011-09-18 Thread Scott Marlowe
On Sun, Sep 18, 2011 at 11:07 PM, Michael Shepanski wrote: > Craig Ringer writes: >> >>Thoughts, folks? Does this matter in practice, since anything you'd >> want to index will in practice be small enough or a candidate for >> full-text indexing? > > Here's my case: the field is meant to hold a pe

Re: [GENERAL] index row requires 10040 bytes, maximum size is 8191

2011-09-18 Thread Michael Shepanski
Craig Ringer writes: > >Thoughts, folks? Does this matter in practice, since anything you'd > want to index will in practice be small enough or a candidate for > full-text indexing? Here's my case: the field is meant to hold a person's name, so it's usually well under the 8191-byte limit. I want

Re: [GENERAL] warm standby - apply wal archives

2011-09-18 Thread Venkat Balaji
Syncing just WAL archive directory every minute should not be a problem at all (running rsync every minute for a data directory is not recommended). As said earlier, we had configured warm standby for a db of size 2 TB and wal archive generation was in 100s. We did not encounter any issues in run

[GENERAL] duplicate sequence, it is possible?

2011-09-18 Thread Anibal David Acosta
Hi everyone. I have a table with a PK, this table has a lot of insert per second (100 ~ 150 insert /sec) Sometimes, a get a duplicate key error, but ID is generated from a function (VOLATILE). This function has just one line (select nextval('XXX')) Is possible that this function return sam

Re: [GENERAL] PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4

2011-09-18 Thread Toby Corkindale
On 17/09/11 00:09, Vick Khera wrote: On Tue, Sep 13, 2011 at 9:15 PM, Toby Corkindale wrote: However we have a new contender - ZFS performed *extremely* well on the latest Ubuntu setup - achieving triple the performance of regular ext4! Did you do any tuning to ZFS? There are many tweaks to

Re: [GENERAL] different unnest function [SOLVED]

2011-09-18 Thread Ondrej Ivanič
Hi, > to get the output OP wants, you need to expand and rewrap: > create or replace function unnest2(anyarray) returns setof anyarray AS > $BODY$ > select array(select unnest($1[i:i])) from > generate_series(array_lower($1,1), array_upper($1,1)) i; > $BODY$ > language 'sql'; Yup, this is what I

Re: [GENERAL] Alternative JDBC driver

2011-09-18 Thread Dave Cramer
Jimmy, What was your question ? The JDBC list is not dead. Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca 2011/9/18 Jimmy K. : > Thanks for answer, we will try this driver, because it's more > promising, if we will found some bugs or suggestion, You will be > informed (I a

Re: [GENERAL] Indexes not allowed on (read-only) views: Why?

2011-09-18 Thread Stefan Keller
Hi Craig, Thank you for the explanations. 2011/9/17 Craig Ringer : > It sounds like they probably use a materialized view, possibly stored as an > index-oriented table. That'd be a cool thing to support, but if done that > way would require TWO new major features PostgreSQL doesn't have. Just to

Re: [GENERAL] Foreign tables using postgresql_fdw or odbc_fdw

2011-09-18 Thread Adrian Klaver
On Sunday, September 18, 2011 6:32:43 am Edson Carlos Ericksson Richter wrote: > Tried both, but they don't work for 9.1. > > I want to thank Adrian, without his help I would never find the link that > confirmed the postgresql_fdw is not working. > > Would be nice to make all this information cle

[GENERAL] New feature in file_fdw

2011-09-18 Thread pasman pasmański
Hi. I propose that some options for foreign tables may be stored as defaults in server object: format, encoding, delimiter, quote. -- pasman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpre

Re: [GENERAL] Alternative JDBC driver

2011-09-18 Thread Jimmy K.
Thanks for answer, we will try this driver, because it's more promising, if we will found some bugs or suggestion, You will be informed (I assume driver is stage that some ideas may be included with no problem). Btw, when I wanted to download driver from other station, I was saw Beta 1 driver (and

[GENERAL] Foreign tables using postgresql_fdw or odbc_fdw

2011-09-18 Thread Edson Carlos Ericksson Richter
Tried both, but they don't work for 9.1. I want to thank Adrian, without his help I would never find the link that confirmed the postgresql_fdw is not working. Would be nice to make all this information clear in Foreign Data Wrapper documentation at PostgreSQL manuals. I wasted at least 12 hours