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
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 s.ravikris...@aim.com wrote:
I am writing bench mark scripts and as part of it would like to clear the
cache
programmatically. This is to ensure
Hi Daniel:
On Mon, May 11, 2015 at 5:30 PM, Daniel Begin jfd...@hotmail.com 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
On Wed, May 13, 2015 at 9:24 AM, Lukas Lehner webleh...@gmail.com 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
On 11 May 2015 at 19:01, Daniel Begin jfd...@hotmail.com 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
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 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 05/13/2015 06:50 AM, Jim Mlodgenski wrote:
On Wed, May 13, 2015 at 9:43 AM, Yves Dorfsman y...@zioup.com
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
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
On Wed, May 13, 2015 at 9:43 AM, Yves Dorfsman 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 together. We hope to have them up soon.
Will you be posting on this
On Wed, May 13, 2015 at 3:50 PM, Jim Mlodgenski jimm...@gmail.com 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
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
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
On Wed, May 13, 2015 at 4:38 PM, Bruce Momjian br...@momjian.us 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,
On Wed, May 13, 2015 at 06:23:58PM -0400, Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
On Wed, May 13, 2015 at 06:10:26PM -0400, Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
Is there a reason the following patch wasn't applied?
I don't think anybody ever did the
Bruce Momjian br...@momjian.us writes:
On Wed, May 13, 2015 at 06:10:26PM -0400, Tom Lane wrote:
Bruce Momjian br...@momjian.us 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
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 creation is
On Wed, May 13, 2015 at 06:10:26PM -0400, Tom Lane wrote:
Bruce Momjian br...@momjian.us 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
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 INTO
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 jeff.ja...@gmail.com writes:
For the record, the culprit that causes analyze; of a database
Bruce Momjian br...@momjian.us 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.
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
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 Herrera
Bruce Momjian br...@momjian.us 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
---
So perhaps replace the SQL SELECT INTO with SQL ADD INTO ?
On Wed, May 13, 2015 at 8:54 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Bruce Momjian br...@momjian.us writes:
On Wed, May 13, 2015 at 06:05:43PM -0600, Yves Dorfsman wrote:
Will `SELECT INTO` be deprecated? It is very convenient when
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
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
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
On Tue, May 12, 2015 at 11:23 PM, Fabio Ugo Venchiarutti fa...@vuole.me
wrote:
Is there any cleaner way to, say, only run the validation part of a type
input function
[...]
This pre-supposes that said type input function has a distinct validation
phase as opposed to simply performing its
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.
--
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
32 matches
Mail list logo