Skip to main content
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 13 years, 7 months
  • Last seen more than a month ago
64 votes
6 answers
87k views

About single threaded versus multithreaded databases performance

26 votes
2 answers
68k 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
5k 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
3k views

Should I create an index for non key columns?

3 votes
1 answer
3k views

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

3 votes
1 answer
3k views

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

3 votes
3 answers
8k views

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

3 votes
1 answer
12k views

How to generate time in milliseconds in PostgreSQL stored procedure?

3 votes
1 answer
25k views

error: must be owner of relation USER_ACCOUNT_ID_seq

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
771 views

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

2 votes
1 answer
649 views

How to perform asynchronous cascade slave replication of PostgreSQL database?

1 vote
1 answer
335 views

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

1 vote
1 answer
2k views

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

0 votes
1 answer
281 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
599 views

Azure automatic fail-over vs always on availability groups clarification