Hello
You could just use temporary tables like:
BEGIN;
CREATE TEMPORARY TABLE csid (i int);
-- somehow write the ID you want into that table
-- and then...
INSERT INTO other_table (changeset_ids, msg) VALUES
((SELECT i FROM csid), 'Some log message');
COMMIT;
When insertin
On Tue, 9 Apr 2013 07:25:16 -0700 (PDT)
Kevin Grittner wrote:
> Christian Hammers wrote:
>
> > 9.2.3
>
> You really need to think about 9.2.4 Real Soon Now; there's a
> security fix that you probably should not wait on.
Is scheduled (no access from outside to tha
Hello
On Tue, 9 Apr 2013 03:53:13 -0700 (PDT)
Greg Williamson wrote:
> Christian --
>
>
>
> postgres version ?
9.2.3
> type of replication ?
As written, one master does streaming replication to two slaves.
> changes from postgres config defaults ?
max_connections = 1000
Hello
I have a setup with one master and two slaves which are used by a closed
source application. The database is asked the same query, a stored procedure,
with different parameters about 4 million times per second at a peak rate of
150 times per second using 10 parallel connections. The slaves a
Am Sun, 30 Dec 2012 15:54:32 +0100
schrieb Philipp Kraus :
> Hello,
>
> can I set all rights to a schema and its content? I have different
> schema and in the public schema all users should be do everything
> (select, update, delete, call functions, etc). Also if I add a new
> user, the user shou
Am Fri, 28 Dec 2012 00:47:35 -0500
schrieb François Beausoleil :
>
> Le 2012-12-27 à 09:54, Kirk Wythers a écrit :
>
> > I have been using COPY FROM to do a mass import of records from CSV
> > files into a new database. I have discover however, a small number
> > of records ( a few thousand) in
use in an index?
> I know that i'll be punished if my guarantee fails...
>
> Regards,
>
>
> On Fri, Dec 21, 2012 at 10:12 AM, Christian Hammers wrote:
>
> > Hello
> >
> > On Fri, 21 Dec 2012 08:46:14 -0200
> > Alex Pires de Camargo
Hello
On Fri, 21 Dec 2012 08:46:14 -0200
Alex Pires de Camargo wrote:
> Is it possible?
>
>Thanks!
Why not?
devel_np=# CREATE TABLE t (i int);
CREATE TABLE
devel_np=# CREATE INDEX ON t (length(i::text), i);
CREATE INDEX
bye,
-christian-
--
Sent via pgsql-general mailing list (p
Hello
I was just wondering the same. As for the slave, it seems to me that
the "ps fax" output "postgres: startup process recovering" is at least
a quick way to check if the replication client has synced.
In a case where e.g. the slave was down for a while and then unsuccessfully
waits for WAL
Hello
I'm trying to figure out how to configure a logcheck compatible logfile
rotation i.e. where
a) the current logfile always has a fixed name and old files are named like
"*.1", "*.2.gz" etc. and
b) the current logfile is not truncated but newly created (or else logcheck
always warns ab
Hello
Do you want to search for tables with many unordered rows?
SELECT
schemaname, tablename, correlation
FROM
pg_stats
WHERE
abs(correlation) < 0.2 and
schemaname not in ('pg_catalog', 'information_schema')
;
Or do you want to put the table in order?
BEGIN;
CRE
Hello
The release notes of PostgreSQL 9.2 praise "SP-GIST" as a major feature
but I cannot find any information on how to actually use it.
The main documentation seems unusual low level and the examples chapter
just refers to the source code. The only examples I can find there are
the regression
Hello
Can you remember where did you read that? There is no mention of GIST on
http://www.postgresql.org/docs/9.2/static/upgrading.html and a database
which uses GIST indexes *seems* to work just finde after upgrading with
pg_upgrade.
bye,
-christian-
Am Mon, 22 Oct 2012 15:02:13 -0700
schrieb
Hello
I run two PostgreSQL servers in a master-slave setup and set
wal_keep_segments=1000 on the master to allow long downtimes on the slave.
Meanwhile the disk got fuller than I estimated and I changed the config
to wal_keep_segments=500 and restarted the server afterwards.
Yet, the number of
Hello
Just because I added a "LIMIT 1" to the following query, PostgreSQL decided to
use a different index which gives a far worse performance :-(
Probably it gets a bit confused because I use the custom index from the prefix
extension (https://github.com/dimitri/prefix/blob/master/README.txt).
I
15 matches
Mail list logo
