,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
).
It seems a bug
It is definitely not a bug, but a desired behaviour deriving from the
MVCC architecture.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general
never replied to that.
Next time, please post the version you are using and possibly the
operating system.
> It's incredible, DB don't change dimension even after 1 million insert
and
> update.
> CPUs average load drastically is fallen down!
Glad you fixed it.
Ciao
Il 30/10/10 10:52, RP Khare ha scritto:
I want pgsql to take automatic scheduled backup of the database every
30 minutes. How to do this?
On Unix like systems, you can set a crontab that executes pg_dump every
30 minutes.
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training
to psql or by
setting the PGUSER environment variable.
> I can rebuild from sources, if needed.
I believe there is no need to do that.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
the right port and host (or Unix socket) to
psql.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
always a good thing.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
on High Performance (which you can find from here:
http://www.postgresql.org/docs/books/)
Merry Christmas to you too!
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent vi
-2010-td3288085.html
[1]
http://archives.postgresql.org/pgsql-hackers/2010-12/msg00087.php [2]
I totally missed this. Thanks for posting it.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuad
from record_table r where r.id > 2;
Have a look on the documentation about this kind of issues, which has
been improved from version 9
(http://www.postgresql.org/docs/9.0/interactive/plpgsql-implementation.html#PLPGSQL-VAR-SUBST).
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Ita
understood your request. Thanks.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
quot;. The problem is that it seems only available
for
Postgres 9.1, while we have obviously started with the latest
release.
Does anybody know how to compile orafce for 9.2 or if there is any
other solution to add some basic oracle functions (dual table, TRUNC,
ecc...)??
Thanks a lot,
Paolo
--
ng it.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresq
get will be included in the recovered server.
For further information, I suggest you look at:
http://www.postgresql.org/docs/9.2/static/recovery-target-settings.html
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@
I second Bruce. I massively use asciidoc. I guess adding both asciidoc and
md would not be too hard.
Thanks,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
2014-02-12 6:02 GMT+01:00 Pavel
/support/professional_support) and let them do
the job for you. Probably cheaper and safer.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql
7;t help that much, given that
we have a fairly good storage? Just trying to get some
ideas before starting testing
(table will be 5M rows, where some of the group by
select could return 3-400K groups)
Leonardo
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and
writing
(http://projects.2ndquadrant.com/repmgr) which should make this kind of
things much easier for you.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql
ilability and Replication conference.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
list of objects for pg_dump.
It may sound unrelated at first, but if you have PostgreSQL 9.1 this use
case matches very well with the new EXTENSION framework. Please look at
the CREATE EXTENSION command and evaluate it.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL
seful
to manage very large data sets.
What you are looking for is called 'partitioning' (horizontal
partitioning). I suggest that you read this chapter:
http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
Post
s you more flexibility and allows you to
change a tool for a specific component in the future without changing
the whole architecture.
Of course, I take it for granted that you have already thought about
the data warehouse layer (in case you have one).
Cheers,
Gabriele
--
Gabriele
;
schema.
Please let me have more information if my assumption were wrong.
Cheers,
Gabriele
Tip/Note: by default, search_path is set to search in the "$user" and
public schemas. Therefore, if you connect using the "system_data" user,
you do not need to force searching
r and give
feedback.
Thank you.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
Array-ELEMENT-foreign-key-v1-refreshed.patch.bz2 | patch -p1
Then regular configure and make procedures
(http://www.postgresql.org/docs/current/interactive/install-procedure.html)
Useful link too: http://wiki.postgresql.org/wiki/Developer_FAQ
Hope this helps.
Thanks,
Gabriele
--
Gabriele
eally much appreciated.
Cheers,
Gabriel
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ould update the commitfest.postgresql.org website. For now, I have
updated that for you and the patch now reports you as a reviewer and
links the message to the patch. Here it is:
https://commitfest.postgresql.org/action/patch_view?id=900
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
Post
is the possibility to
build a sync between a 32 and a 64 bit (on linux)?
As stated in the documentation
(http://www.postgresql.org/docs/9.0/static/warm-standby.html), the
hardware architecture must be the same.
Hope this helps.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
Post
Hi Alex,
Of course "select ... into" doesn't work, but how should I do it?
Can't find in http://www.postgresql.org/docs/8.1/static/
You might want to look at the CREATE TABLE AS command. You might even
use the temporary definer.
Ciao,
Gabriele
--
Gabriele Bartolini
mainly in terms of
inserts/updates/deletes.
I would gradually try and increase checkpoint_segments by 32 and
monitor the effects.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
-
it implied that I need to add 'postgres'
maintenance database in there or something else?
If the user carlos in your database has replication privileges, you can
try and execute the commands by connecting to the postgres database (if
your pg_hba.conf file allows you to do that, but t
sebackup.html
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I could help you more here, but most of our professional work is
performed under strict NDAs.
An interesting and useful documentation section is this also:
http://www.postgresql.org/docs/9.1/interactive/high-availability.html
I hope this helps.
Cheers,
Gabriele
--
Gabriele Bartolini
idea
to add it as admin function (I will have a think about it and possibly
come up with a patch).
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general mail
Hi Toby,
Il 29/03/12 10:46, Gabriele Bartolini ha scritto:
Currently, there's no such a function. In general we simply check if a
'backup_label' file exists in PGDATA. However, it could be a good idea
to add it as admin function (I will have a think about it and possibly
come
tion).
I suggest that you look at the -l and -L options in pg_restore, which
allow you to select which dump entries to restore (selective restore).
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQ
Hi guys,
just a quick and probably stupid question. When I make a cluster
based on an index on a table, how can I remove it later? Should I
'create' a new one by using the primary key index?
Also, can I have more than 1 cluster on my table? Let me explain ...
can I put for instance the reco
37 matches
Mail list logo
