4,440 reputation
422
bio website manitou-mail.org/about-dv.php
location Paris, France
age
visits member for 2 years, 8 months
seen 1 min ago

Let's try to share the bits of knowledge gained during those innumerable hours of programming... Nowadays I use mostly PostgreSQL, C++/Qt, Perl, php on Unix servers.


22h
revised Oracle Import problem caused by different character sets
fixed typo in title and minor formatting changes
1d
answered After upgrade from 9.1 to 9.3, commands still point to 9.1
1d
revised pgbench-tools failed authentication
minor typo fix and formatting
1d
reviewed Approve suggested edit on MySQL Circular replication with fail over
2d
answered Why “SET LOCAL statement_timeout” does not work as expected with PostgreSQL functions?
Nov
14
comment Looking for a recipe to merge multiple rows to single row
This table looks like an input queue. I'd consider a queue implementation with, at its output, an always-running consumer to consolidate the rows. Have a look at PGQ
Nov
13
awarded  Nice Answer
Nov
11
reviewed Approve suggested edit on how best to add unique index on nvarchar(max) field on existing table
Nov
7
answered Matching a value with every element of a set of values - Postgresql
Nov
5
revised Deadlock detected on CREATE TABLE in PostgreSQL
added 4 characters in body
Nov
5
answered Deadlock detected on CREATE TABLE in PostgreSQL
Nov
5
answered TRUNCATE in transaction: dead lock
Nov
5
comment Deadlock detected on CREATE TABLE in PostgreSQL
Are you sure there isn't a 3rd operation (besides create table A & create table B) that would need to acquire a lock on either A,B or C? Can you reproduce the deadlock in two parallel psql sessions?
Oct
29
comment postgresql - a local replication entry doesn't work
Unix domain sockets are refered to with local and never localhost. Anyway the question never mentions localhost in the first place, so it's not obvious why it would even be involved here.
Oct
26
reviewed Approve suggested edit on TYPE_SYM syntax error when running the mysql command to create or replace type
Oct
24
comment Postgresql single base on multiple HDD partitions
OK. I'd symlink large directories and tranfer their contents to another partition, with pg_xlog being the first candidate if it's big. Once the db is running again, analyze how it's growing and figure a plan to scale using tablespaces.
Oct
24
comment Postgresql single base on multiple HDD partitions
Could you run this at the top of the data directory: du -sh base/* pg_xlog/ and add the results to the question?
Oct
24
answered How to import large sql file in postgres?
Oct
22
answered Why Postgresql 9.2 word boundary not working!
Oct
18
answered Postgres blocking UPDATE on new column?