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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
15 matches
Mail list logo
