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
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
-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 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
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
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
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
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
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
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
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
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,
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
13 matches
Mail list logo
