I am writing bench mark scripts and as part of it would like to clear the cache
programmatically. This is to ensure that when we run select queries the data is
not read read from the cache. Does PG provide any easy way to do it other than
the obvious way to restart the database.
Thanks.
--
Sent
On 13/05/15 20:13, Ravi Krishna wrote:
I am writing bench mark scripts and as part of it would like to clear the cache
programmatically. This is to ensure that when we run select queries the data is
not read read from the cache. Does PG provide any easy way to do it other than
the obvious way to
I wrote a few notes on doing this here:
http://hollobon.com/_pgblog/clear_shared_buffers.html
Thanks,
Pete.
On 13 May 2015 at 09:13, Ravi Krishna wrote:
> I am writing bench mark scripts and as part of it would like to clear the
> cache
> programmatically. This is to ensure that when we run sel
Hi,
I would like to check whether PostgreSQL is compliant with OGC. If it is,
can you provide me the documentation to it?
Regards,
Yoong Zhen
Hi Daniel:
On Mon, May 11, 2015 at 5:30 PM, Daniel Begin wrote:
> How big? According to PgAdmin my personal database is about 2TB...
I do not know what pgAdmin reports, I was thinking in how bick a dump
( using -Fc, which compresses on th fly ) is, to see wheter you can
restore.
> How critical?
Yoong Zhen,
* Yoong Zhen Ang (y0z0...@gmail.com) wrote:
> I would like to check whether PostgreSQL is compliant with OGC. If it is,
> can you provide me the documentation to it?
If you're talking about Open Geospatial Consortium, then what you really
want is PostGIS, the spatial extension to Post
Hi,
On Wed, 2015-05-13 at 07:49 -0400, Stephen Frost wrote:
> http://www.postgis.org
The URL is actually
http://www.postgis.net
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter:
On 11 May 2015 at 19:01, Daniel Begin wrote:
> Interesting,
>
> The symbolic links on the old drive -still used by the DB- look like
> windows' shortcuts to parent folder, while they are empty folders in the
> copy of the database I have on the new drive...
>
> When I do a plane copy of those link
Hi
Where can I download PGConf NYC 2015 videos? Was there a recording?
I live in Europe. Please point me to torrent link.
There are lots of interesting talks.
Lukas
On Wed, May 13, 2015 at 9:24 AM, Lukas Lehner wrote:
> Hi
>
> Where can I download PGConf NYC 2015 videos? Was there a recording?
>
>
Yes, the talks were recorded. There was a lot of content so we are still
working on getting everything together. We hope to have them up soon.
> I live in Europe
On 2015-05-13 07:37, Jim Mlodgenski wrote:
>
> Yes, the talks were recorded. There was a lot of content so we are still
> working on getting everything together. We hope to have them up soon.
>
Will you be posting on this list when they are ready?
--
http://yves.zioup.com
gpg: 4096R/32B0F416
On Wed, May 13, 2015 at 9:43 AM, Yves Dorfsman wrote:
> On 2015-05-13 07:37, Jim Mlodgenski wrote:
> >
> > Yes, the talks were recorded. There was a lot of content so we are still
> > working on getting everything together. We hope to have them up soon.
> >
>
> Will you be posting on this list wh
On Wed, May 13, 2015 at 3:50 PM, Jim Mlodgenski wrote:
> We were not planning on posting to -general because to me it seems off
> topic, but if no one objects we can. We were planning on announcing it
> through the normal social media channels for the conference like
> the @PGConfUS Twitter handl
On 05/13/2015 06:50 AM, Jim Mlodgenski wrote:
On Wed, May 13, 2015 at 9:43 AM, Yves Dorfsman mailto:y...@zioup.com>> wrote:
On 2015-05-13 07:37, Jim Mlodgenski wrote:
>
> Yes, the talks were recorded. There was a lot of content so we are still
> working on getting everything to
On Thu, Sep 20, 2012 at 09:42:33AM +0800, Craig Ringer wrote:
> Hi all
>
> I'm wondering if there's any way to convince `to_char` to add a leading zero
> to
> the hours in negative intervals. The current behaviour feels wrong, in that
> FMHH24:MM and HH24:MM produce the same output for negative i
Thank Francisco,
After having poked around for a while to move it with Windows, I think I've
finally understood a couple of things...
- Since my old drive contains the PGDATA folder, I actually need to move the
whole PostgreSQL cluster (almost).
- Windows backup/copy/xcopy failed to do the job,
On 5/13/2015 11:06 AM, Daniel Begin wrote:
I am then currently running pg_dumpall on the database. I will restore the cluster on the
new drive once completed. However, there is still something obscure in the process. The
doc says "pg_dumpall requires all needed tablespace directories to exist b
Thank John,
I was naive hoping I just had to run "$ psql -f pgdumpall.output postgres"...
but it makes sense since the drive on which it is all stored won't be there
anymore.
So let's read initdb documentation :-)
Daniel
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mail
Is there a reason the following patch wasn't applied?
---
On Thu, Oct 4, 2012 at 07:14:31PM -0400, Tom Lane wrote:
> Jeff Janes writes:
> > For the record, the culprit that causes "analyze;" of a database with
> > a large
Bruce Momjian writes:
> Is there a reason the following patch wasn't applied?
I don't think anybody ever did the legwork to verify it was a good idea.
In particular, it'd be good to check if sending a tabstat message for each
table adds noticeable overhead.
regards, tom l
On Wed, May 13, 2015 at 06:10:26PM -0400, Tom Lane wrote:
> Bruce Momjian writes:
> > Is there a reason the following patch wasn't applied?
>
> I don't think anybody ever did the legwork to verify it was a good idea.
> In particular, it'd be good to check if sending a tabstat message for each
> t
Bruce Momjian writes:
> On Wed, May 13, 2015 at 06:10:26PM -0400, Tom Lane wrote:
>> Bruce Momjian writes:
>>> Is there a reason the following patch wasn't applied?
>> I don't think anybody ever did the legwork to verify it was a good idea.
>> In particular, it'd be good to check if sending a ta
Is there any way to add an ON COMMIT clause to a SELECT INTO TEMP TABLE?
Thanks.
--
http://yves.zioup.com
gpg: 4096R/32B0F416
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, May 13, 2015 at 05:29:36PM -0600, Yves Dorfsman wrote:
>
> Is there any way to add an ON COMMIT clause to a SELECT INTO TEMP TABLE?
Well CREATE TABLE has a ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP }
clause, but I don't see it in SELECT INTO, so it seems you have to
create the temp t
On Wed, May 13, 2015 at 4:38 PM, Bruce Momjian wrote:
> On Wed, May 13, 2015 at 05:29:36PM -0600, Yves Dorfsman wrote:
> >
> > Is there any way to add an ON COMMIT clause to a SELECT INTO TEMP TABLE?
>
> Well CREATE TABLE has a ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP }
> clause, but I don'
On Wed, May 13, 2015 at 05:29:36PM -0600, Yves Dorfsman wrote:
> Is there any way to add an ON COMMIT clause to a SELECT INTO TEMP TABLE?
On 2015-05-13 17:56, David G. Johnston wrote:
> From the documentation of SELECT INTO
>
> "
> The PostgreSQL usage of SELECT INTO to represent table creatio
On Wed, May 13, 2015 at 06:23:58PM -0400, Tom Lane wrote:
> Bruce Momjian writes:
> > On Wed, May 13, 2015 at 06:10:26PM -0400, Tom Lane wrote:
> >> Bruce Momjian writes:
> >>> Is there a reason the following patch wasn't applied?
>
> >> I don't think anybody ever did the legwork to verify it wa
On Wed, May 13, 2015 at 06:05:43PM -0600, Yves Dorfsman wrote:
>
> On Wed, May 13, 2015 at 05:29:36PM -0600, Yves Dorfsman wrote:
> > Is there any way to add an ON COMMIT clause to a SELECT INTO TEMP TABLE?
>
> On 2015-05-13 17:56, David G. Johnston wrote:
> > From the documentation of SELECT IN
Bruce Momjian writes:
> On Wed, May 13, 2015 at 06:05:43PM -0600, Yves Dorfsman wrote:
>> Will `SELECT INTO` be deprecated? It is very convenient when writing pgplsql
>> functions, to select into a record.
> The pl/psql `SELECT INTO` is not related to the SQL SELECT INTO command
> --- yeah, confu
So perhaps replace the SQL SELECT INTO with SQL ADD INTO ?
On Wed, May 13, 2015 at 8:54 PM, Tom Lane wrote:
> Bruce Momjian writes:
> > On Wed, May 13, 2015 at 06:05:43PM -0600, Yves Dorfsman wrote:
> >> Will `SELECT INTO` be deprecated? It is very convenient when writing
> pgplsql
> >> functio
Melvin Davidson wrote:
> So perhaps replace the SQL SELECT INTO with SQL ADD INTO ?
No, the alternative spelling is CREATE TABLE AS; we already have it.
(To simply insert a query result into an existing table, the spelling is
INSERT INTO .. SELECT).
--
Álvaro Herrerahttp://www.2
31 matches
Mail list logo
