On Thu, Aug 22, 2013 at 6:36 PM, Ian Lawrence Barwick wrote:
> INSERT INTO t (t_field1, t_field2, t_field3)
> SELECT r.field1, r.field2, (x+y)
> FROM r
>
Obligatory link to documentation:
http://www.postgresql.org/docs/9.2/static/sql-insert.html. See where it
says [ ( *column_name* [, ...]
On Fri, Aug 23, 2013 at 12:44 AM, bricklen wrote:
> On Thu, Aug 22, 2013 at 8:40 AM, Tom Lane wrote:
>>
>>
>> There is some setting that controls whether such messages appear at
>> all
>
>
> Is it "log_temp_files"?
Exactly. More reference here:
http://www.postgresql.org/docs/devel/static/runtime-
高健 escribió:
> ...
> Checkpoints are fairly expensive, first because they require writing out
> all currently dirty buffers, and second because they result in extra
> subsequent WAL traffic as discussed above.
> ...
>
> What confused me is that: (checkpoint)result in extra subsequent WAL
> traff
Hello:
Sorry for disturbing.
I have one question : Will checkpoint cause wal written happen?
I found the following info at:
http://www.postgresql.org/docs/9.2/static/wal-configuration.html
...
Checkpoints are fairly expensive, first because they require writing out
all currently dirty buffe
Hi:
Thank you all for kindly replying.
I think that I need this: pg_stat_user_tables.n_tup_hot_upd
And Adrian's information is a pretty good material for me to understand
the internal.
Best regards
2013/8/22 Adrian Klaver
> On 08/21/2013 07:20 PM, 高健 wrote:
>
>> Hi:
>>
>> I have hear
On Thu, Aug 22, 2013 at 5:12 PM, Vincent Veyron wrote:
> Le jeudi 22 août 2013 à 11:29 -0400, Don Parris a écrit :
>
> > Still, how could I have made UTF-8 the default encoding at install
> > time?
>
> I did several recent installations of Postgresql on Debian Wheezy with
> UTF8 and LATIN9, and
2013/8/23 Robert James :
> I would like to:
>
> INSERT INTO t
> SELECT * FROM r, (x + y) AS field3
>
> How do I correlate the names of the fields? That is, how do I indicate
> which fields from r or field3 should be inserted into the right
> columns in t?
INSERT INTO t (t_field1, t_field2, t_field
On Thu, Aug 22, 2013 at 3:30 PM, Robert James wrote:
> I would like to:
>
> INSERT INTO t
> SELECT * FROM r, (x + y) AS field3
>
INSERT INTO t (col1, col2, col3)
SELECT ...
I would like to:
INSERT INTO t
SELECT * FROM r, (x + y) AS field3
How do I correlate the names of the fields? That is, how do I indicate
which fields from r or field3 should be inserted into the right
columns in t?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
On Thu, Aug 22, 2013 at 11:29 AM, Don Parris wrote:
> On Thu, Aug 22, 2013 at 3:23 AM, Stuart Bishop wrote:
>
>> On Wed, Aug 21, 2013 at 4:55 PM, Don Parris wrote:
>>
>>
> you install the PostgreSQL packages, it runs pg_createcluster for you.
>> If you don't like the locale or encoding you use
Le jeudi 22 août 2013 à 11:29 -0400, Don Parris a écrit :
> Still, how could I have made UTF-8 the default encoding at install
> time?
I did several recent installations of Postgresql on Debian Wheezy with
UTF8 and LATIN9, and my system's encoding was used every time.
Installation steps outl
On Tue, Aug 20, 2013 at 2:23 PM, Adrian Klaver wrote:
> PostgreSQL never examines the content of a literal string before determining
> its type, and therefore will treat both of the above as timestamp without
> time zone. To ensure that a literal is treated as timestamp with time zone,
> give it t
On Thu, Aug 22, 2013 at 8:40 AM, Tom Lane wrote:
>
> There is some setting that controls whether such messages appear at
> all
>
Is it "log_temp_files"?
"Nicholson, Brad (Toronto, ON, CA)" writes:
> I'm seeing cases where I have temp files being written on commit, such as.
> 2013-08-16 12:09:02 GMT [14480]: [588-1] user=dbuser,db=dbname STATEMENT:
> COMMIT
> 2013-08-16 12:09:02 GMT [14480]: [589-1] user= dbuser,db=dbname LOG:
> temporary file
On Thu, Aug 22, 2013 at 3:23 AM, Stuart Bishop wrote:
> On Wed, Aug 21, 2013 at 4:55 PM, Don Parris wrote:
>
> > I did run pg_dropcluster, pg_createcluster (setting locale to C.UTF8) -
> and
> > that seemed to work, except that I could not thereafter make remote
> > connections (despite resetting
On Wed, Aug 21, 2013 at 12:55 PM, carlosinfl . wrote:
> I'm trying to understand how 9.2.4 logs common tasks and info in
> CentOS 6.4 Linux. It appears everything is stored in
> /var/lib/pgsql9/data/pg_log/postgresql-%a.log
>
> My issue is the logging information is fairly missing / light. I only
Hi,
I'm seeing cases where I have temp files being written on commit, such as.
2013-08-16 12:09:02 GMT [14480]: [588-1] user=dbuser,db=dbname STATEMENT:
COMMIT
2013-08-16 12:09:02 GMT [14480]: [589-1] user= dbuser,db=dbname LOG: temporary
file: path "base/pgsql_tmp/pgsql_tmp14480.263", size 8
On 08/21/2013 07:20 PM, 高健 wrote:
Hi:
I have heard that Heap-Only Tuples is introduce from 8.3.
And I am searching information for it.
How can I get a detailed information of HOT?
http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/access/heap/README.HOT;hb=HEAD
For ex
On Wed, Aug 21, 2013 at 4:55 PM, Don Parris wrote:
> I did run pg_dropcluster, pg_createcluster (setting locale to C.UTF8) - and
> that seemed to work, except that I could not thereafter make remote
> connections (despite resetting the hba and postgres.conf files as they
> should be).
Rather tha
On Thu, Aug 22, 2013 at 2:46 AM, Ivan Radovanovic wrote:
> Just to verify:
> - when unique index is created row is added only to pg_index table but not
> to pg_constraint table (although in fact that index is behaving like
> constraint on table)
Yep.
postgres=# create table foo (a int);
CREATE TAB
Hello,
I'd like to setup a testing environment which is based on a current
production server status. The DB server is pgsql 8.4 (subscribed RHEL, so
can't use hot standby or other 9.0+ options). The objective is to have a db
server that I could clone many times a day to auto-build many testing
env
21 matches
Mail list logo
