Jérôme Verstrynge's user avatar
Jérôme Verstrynge's user avatar
Jérôme Verstrynge's user avatar
Jérôme Verstrynge
  • Member for 12 years, 9 months
  • Last seen more than 1 year ago
63 votes
6 answers
86k views

About single threaded versus multithreaded databases performance

26 votes
2 answers
67k views

PgAdmin III - How to connect to database when password is empty?

7 votes
2 answers
13k views

SQL command to remove prefix from a set of tables

5 votes
2 answers
4k views

How many rows can SQL Server process in a single INSERT statement into a table?

4 votes
2 answers
5k views

How expensive are SELECT FROM LIKE statements from a design perspective?

4 votes
1 answer
4k views

Could not open file "pg_clog/0000": No such file or directory

4 votes
2 answers
2k views

Should I create an index for non key columns?

3 votes
1 answer
25k views

error: must be owner of relation USER_ACCOUNT_ID_seq

3 votes
3 answers
7k views

Can a TRUNCATE or DROP table ever be very time consuming?

3 votes
1 answer
3k views

Is it possible to convert a .mysql file to a .sql file?

2 votes
1 answer
10k views

How to generate time in milliseconds in PostgreSQL stored procedure?

2 votes
2 answers
2k views

Is there a benefit/drawback to adding LIMIT 0,1 when performing SELECT on unique key field?

2 votes
1 answer
752 views

Can I use a Clob as a table key (from Java)?

2 votes
1 answer
636 views

How to perform asynchronous cascade slave replication of PostgreSQL database?

2 votes
1 answer
3k views

How to set isolation to SERIALIZABLE DEFERRABLE for a whole Postgresql database? [closed]

1 vote
1 answer
2k views

Explain PostgreSql ssl_cipher values: ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH

1 vote
1 answer
324 views

How to prepare a date and double for a mysql replace statement?

0 votes
1 answer
262 views

Is there a benefit to using FOR SHARE in this PostgreSql simple select?

0 votes
1 answer
2k views

How to update array fields in a table in Postgresql?

0 votes
1 answer
503 views

Azure automatic fail-over vs always on availability groups clarification