On 13 Oct 2010, at 24:03, sunpeng wrote:
> Hi, I have the following table:
> CREATE TABLE A
> (
>a1 integer not null,
>a2 integer,
>a3 integer,
>a4 integer
> )
> and have the following four indices:
> create index ind_a1 on A USING gist(a1);
> create index ind_a2 on A USING gist(
On 13 Oct 2010, at 24:03, sunpeng wrote:
> Hi, I have the following table:
> CREATE TABLE A
> (
>a1 integer not null,
>a2 integer,
>a3 integer,
>a4 integer
> )
> and have the following four indices:
> create index ind_a1 on A USING gist(a1);
> create index ind_a2 on A USING gist(
Hi Igor Neyman,
Yeah - I agree with you.
That needs to be changed.
But, I see scope of the improvement in the script, you shared.
That is - what if the service never started, then it will never return from
the script.
We will do the required changes, Thanks for your inputs.
--
Thanks & Regards,
Steve Crawford wrote:
> On 09/25/2010 07:03 AM, Tom Lane wrote:
> > rey writes:
> >
> >> Why limit this to a single character?
> >>
> > Performance. Believe it or not, breaking fields at the delimiter is
> > a significant factor in COPY speed.
> >
> > regards, tom la
On 2010/10/12 8:46, Carlos Mennens wrote:
Just wondering how you guys feel about NoSQL and I just wanted to
share the following article...
http://www.linuxjournal.com/article/10770
Looking to read your feedback and / or opinions.
Seems a nice article. I like it. :)
I think "NoSQL is a new im
Defaulting bytea output from the backend to use hex mode encoding, which is
incompatible with pre-9.0 interfaces, wasn't a friendly thing to do. The
default should have been escape mode. Or else you needed a big warning in
HISTORY that we must either change bytea_output, or upgrade all clients
befo
Thanks. I could give more clues.
The call stack of the function most consumed time is:
Thread [1] (Suspended)
34 ExecInsertIndexTuples()
/home/postgres/develop/postgresql-snapshot/src/backend/executor/execUtils.c:1046
0x08201e66
33 ExecUpdate()
/home/postgres/develop/postgresql-snapshot/src
Well, the objects indices 1,2,3 point to changed when you changed column a4,
but I don't know if that's the reason. I would guess that the indices are
structured as pointers of some kind though.
On Wed, Oct 13, 2010 at 9:03 AM, sunpeng wrote:
>
> the question is why all four indices updated in t
Hi, I have the following table:
CREATE TABLE A
(
a1 integer not null,
a2 integer,
a3 integer,
a4 integer
)
and have the following four indices:
create index ind_a1 on A USING gist(a1);
create index ind_a2 on A USING gist(a2);
create index ind_a3 on A USING gist(a3);
create index ind_a4
Thom Brown wrote:
> Hi,
>
> I noticed that if I run this:
>
> SELECT alias, description, token FROM
> ts_debug('http://www.postgresql.org:2345/directory/page.html?version=9.1&build=alpha1#summary');
>
> I get:
>
> alias | description | token
> --+-
On 12 Oct 2010, at 2:27 AM, Darren Duncan wrote:
Some people would say that "NoSQL" is a contrast with relational
databases but I would say that in fact these things are orthogonal.
You can in fact use the relational model of data over both an ACID
database as over a "NoSQL" database, just
On Mon, Oct 11, 2010 at 6:57 PM, David Boreham wrote:
> http://www.xtranormal.com/watch/6995033/
> (warning: may not be sfw).
ROFLMAO!!!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
This message is CCed to Dave Page, because his name is found in
startserver.vbs script discussed later.
I think there is a (minor?) problem with 8.4.5 Windows installer from
EnterpriseDB (probably othere releases as well - didn't check).
Here is an abstract from the "tail" of my installation lo
> "Carlos" == Carlos Mennens writes:
Carlos> Looking to read your feedback and / or opinions.
Here's what I wrote on the Smalltalk Seaside mailing list a few weeks
back:
I've given a talk a few times about "forget the ORM". The slides are up
on http://www.slideshare.net/RandalSchwartz/fo
carlos.menn...@gmail.com (Carlos Mennens) writes:
> Just wondering how you guys feel about NoSQL and I just wanted to
> share the following article...
>
> http://www.linuxjournal.com/article/10770
>
> Looking to read your feedback and / or opinions.
There's a lot there to agree with, and a lot to
> > > Derk Jan Horstman writes:
> > > After a new install of HP-UX B.11.23 (ia64) and installing the latest
> > > patches on it, I've tried to compile PostgreSQL 9.0.1 from source again.
> > > But I've still got problems with compiling, the process is ending with
> > > the next errors:
> > ip.c:
On Tue, Oct 12, 2010 at 2:58 AM, Peter C. Lai wrote:
> On 2010-10-11 05:57:37PM -0600, David Boreham wrote:
>> On 10/11/2010 5:46 PM, Carlos Mennens wrote:
>> > Just wondering how you guys feel about NoSQL and I just wanted to
>> > share the following article...
>> >
>> > http://www.linuxjournal
17 matches
Mail list logo
