Hello,
My question is about GIST index.
I made my own index to handle specific data and operators. It works
pretty fine but I wonder if it was possible to optimize it.
When I run my operator on a GIST node (in the method
gist_range_consistent) it returns "NotConsistent" / "MaybeConsistent" /
"F
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, June 18, 2014 4:32 AM
To: Khangelani Gama; Andres Freund; Tom Lane
Cc: Alban Hertroys; Ziggy Skalski; pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_restore: custom archiver unexpected end of
-Original Message-
From: Khangelani Gama [mailto:kg...@argility.com]
Sent: Wednesday, June 18, 2014 1:06 PM
To: 'Adrian Klaver'; 'Andres Freund'; 'Tom Lane'
Cc: 'Alban Hertroys'; 'Ziggy Skalski'; 'pgsql-general@postgresql.org'
Subject: RE: [GENERAL] pg_restore: custom archiver unexpected en
Hello. I had a strange issue with postgresql 9.3 server. Load on server
rapidly increased, queries which took about 4ms were executed for 100ms and
creation a foreign key on empty table blocked all queries to server. After
server restart everithing became fine again, the same foreign key was
create
On 06/18/2014 04:05 AM, Khangelani Gama wrote:
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, June 18, 2014 4:32 AM
To: Khangelani Gama; Andres Freund; Tom Lane
Cc: Alban Hertroys; Ziggy Skalski; pgsql-general@postgresql.org
Subject: Re: [GENERA
> What is the sustained volume of disk output you experience, for
> example from vmstat snapshots?
Unfortunately our metrics are... less than comprehensive at this point, so
I don't have data for that at the moment. Going to work to rectify, but
will take some time.
> 10% of 8GB (which is sounds
> Adrian you might be right I have just tried to pg_restore on the same
> server(8.4.2), I get the same errors related to xml. Can someone
> advise if the following XML file as an example is in the correct state or
> not:
The other strange thing is:
ERROR: missing data for column "fpp_cde"
CONTEX
Denis Mironchuk wrote:
> Hello. I had a strange issue with postgresql 9.3 server. Load on
> server rapidly increased, queries which took about 4ms were
> executed for 100ms and creation a foreign key on empty table
> blocked all queries to server. After server restart everithing
> became fine aga
Is there a way to replace a production database with another as part of a
new "release" of our website?
Where I work we have a scheme of pushing code+db releases to "testing" and
then to "production". Most of our databases use MySQL and I was told they
can just rename the db and it works. We are a
On Wed, Jun 18, 2014 at 05:05:22PM -0300, Nicolás Lichtmaier wrote:
> Where I work we have a scheme of pushing code+db releases to "testing" and
> then to "production". Most of our databases use MySQL and I was told they
> can just rename the db and it works. We are adopting PostgreSQL for some
>
On Wed, 18 Jun 2014 17:05:22 -0300 Nicolás Lichtmaier
wrote:
> Is there a way to replace a production database with another as part of a
> new "release" of our website?
>
> Where I work we have a scheme of pushing code+db releases to "testing" and
> then to "production". Most of our databases u
I'm probably doing this wrong, but I couldn't find any resources to learn
how to get this right.
Can the renaming be done without disruption to current connections? From
what I've read you have to disconnect everyone before renaming a database.
2014-06-18 17:47 GMT-03:00 Bill Moran :
> On Wed,
On 18/06/14 21:50, Nicolás Lichtmaier wrote:
> I'm probably doing this wrong, but I couldn't find any resources to
> learn how to get this right.
>
> Can the renaming be done without disruption to current connections?
> From what I've read you have to disconnect everyone before renaming a
> databas
On 6/18/2014 1:05 PM, Nicolás Lichtmaier wrote:
Is there a way to replace a production database with another as part
of a new "release" of our website?
Where I work we have a scheme of pushing code+db releases to "testing"
and then to "production". Most of our databases use MySQL and I was
to
On 6/18/2014 3:05 PM, Nicolás Lichtmaier wrote:
Is there a way to replace a production database with another as part of
a new "release" of our website?
Where I work we have a scheme of pushing code+db releases to "testing"
and then to "production". Most of our databases use MySQL and I was told
Hi, I have a question about getting some information about database changes.
Let's suppose I have a particular transaction ID that I happen to know has
been rolled back.
Is it possible to ask the database if there have been any committed
transactions subsequent
to that rolled-back transaction? Ba
I have a large table of access logs to an application.
I want is to find all rows that overlap startdate and enddate with any
other rows.
The query below seems to work, but does not finish unless I specify a
single id.
select distinct a1.id
from t_access a1,
t_access a2
where tstzr
On 06/18/2014 05:47 PM, Jason Long wrote:
I have a large table of access logs to an application.
I want is to find all rows that overlap startdate and enddate with any
other rows.
The query below seems to work, but does not finish unless I specify a
single id.
select distinct a1.id
from t_acce
On Wed, 2014-06-18 at 18:08 -0600, Rob Sargent wrote:
> On 06/18/2014 05:47 PM, Jason Long wrote:
>
>
> > I have a large table of access logs to an application.
> >
> > I want is to find all rows that overlap startdate and enddate with any
> > other rows.
> >
> > The query below seems to wo
It is possible to define a global value/variable in PostgreSQL in a way that I
can use it in any query/view/function?For example, I do have a connection
string I use for dblink connections in several places (specially, inside
views).Then, if I want to change the connection string, I do have to c
On 19/06/14 11:50, Edson Richter wrote:
It is possible to define a global value/variable in PostgreSQL in a way that I
can use it in any query/view/function?
For example, I do have a connection string I use for dblink connections in
several places (specially, inside views).
Then, if I want to c
Ian Barwick writes:
> On 19/06/14 11:50, Edson Richter wrote:
>> It is possible to define a global value/variable in PostgreSQL in a way that
>> I can use it in any query/view/function?
> There's no such thing as a global variable, but why not use a table
> to store any global configuration valu
On 19 Jun 2014, at 1:47, Jason Long wrote:
> I have a large table of access logs to an application.
>
> I want is to find all rows that overlap startdate and enddate with any
> other rows.
>
> The query below seems to work, but does not finish unless I specify a
> single id.
>
> select dis
23 matches
Mail list logo
