Hi,
in the old days (version 7.x) I created a set of btree operators
create operator <& (
procedure = mytext_lt,
leftarg = text,
rightarg = text,
commutator = >&,
negator = >=&,
restrict = scalarltsel,
join = scalarltjoinsel
);
etc. for a completeoperator class
create operator cla
Hi,
Today on one of databases under my management I found very strange plan for
simple query.
Postgresql 9.0.7 on Linux,
random_page_cost=4
seq_page_cost=1
The query and plan:
db=# EXPLAIN (ANALYZE, COSTS, BUFFERS) select obj_id, obj_commented,p2o_id
FROM blog_post as obj
JOIN person2obj ON p2o
Hi,
I'm wondering ig it is possible to measure elapsed time between 2
particular queries in PostgreSQL.
what I need is the equivalent of @@TIMETICKS in Transac-SQL
or CLOCK_MONOTONIC in Unix
or GetTickCount in Windows
These are not affected by system time changes, so time interval can be
calcula
I am wondering how the catchup mode of a hot synchron slave server works on
9.1.3 if there is no WAL archive.
Can the slave only request WALs that are still in the xlog directory of the
master server? Or does the master regenerate some kind of fake log for the
catchup mode? E.g. in case of a sl
On 04/05/2012 09:35 AM, hans wulf wrote:
> I am wondering how the catchup mode of a hot synchron slave server works on
> 9.1.3 if there is no WAL archive.
http://www.postgresql.org/docs/9.1/interactive/warm-standby.html#STREAMING-REPLICATION
"Streaming replication allows a standby server to sta
haman...@t-online.de writes:
> Now, in versions 8 and later the "using <&-" is rejected,
> the ordering op "needs to be < or > member of a btree operator class".
> What is needed to create the old behaviour again
> - create a complete operator class, including new names for the unchanged
> equal
What abt the compatibility w.r.to PostgreSQL?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/EDB-oracle-compatibility-Nested-Tables-tp5620654p5622857.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (p
I simplified my example somewhat. I usually have six of these "optional"
parameters.
The number of prepared statements would be too many for this approach.
I will follow your advice in the cases where I just one or two of the
"optional" parameters.
Looks like I will need to dynamically build my
On 04/05/12 7:00 AM, Vincent Dautremont wrote:
These are not affected by system time changes, so time interval can be
calculated even if the system time is changed by NTP or the user.
That's why I can't use any function based on system time.
properly configured Unix NTP doesn't step-change the
On 04/06/12 7:21 AM, cognizant wrote:
What abt the compatibility w.r.to PostgreSQL?
community postgresql has no pretentions of being Oracle compatible.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I simplified my example somewhat. I usually have six of
> these "optional" parameters. The number of prepared statements
> would be too many for this approach.
> I will follow your advice in the cases where I just one or two
> of the "optio
On Sat, 2012-03-31 at 13:21 +0200, Janning Vygen wrote:
> The OS was installed a few days before, the i installed the postgresql
> instance. I configured my setup with a backup server by WAL archiving.
> Then i tested some things and i played around with pg_reorg (but i
> didn't use ist till the
On Thu, Apr 5, 2012 at 12:35 PM, hans wulf wrote:
> I am wondering how the catchup mode of a hot synchron slave server works
> on 9.1.3 if there is no WAL archive.
>
Why would you not want to maintain a WAL archive? Are you depending on the
slave server(s) as your only form of backup?
It isn't
13 matches
Mail list logo
