User Jérôme Verstrynge - Database Administrators Stack Exchange

Jérôme Verstrynge

Member for 12 years, 6 months
Last seen more than a month ago

Twitter
GitHub
Nimes, France

Network profile

20 Questions

Score Activity Newest Views

63 votes

6 answers

85k views

About single threaded versus multithreaded databases performance

asked May 24, 2011 at 1:09

26 votes

2 answers

67k views

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

asked Nov 9, 2011 at 14:25

7 votes

2 answers

13k views

SQL command to remove prefix from a set of tables

asked Feb 16, 2012 at 21:28

5 votes

2 answers

4k views

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

asked Dec 14, 2018 at 14:05

4 votes

2 answers

5k views

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

asked Apr 10, 2012 at 0:27

4 votes

1 answer

4k views

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

asked May 28, 2014 at 8:29

4 votes

2 answers

2k views

Should I create an index for non key columns?

asked Mar 8, 2014 at 15:59

3 votes

1 answer

24k views

error: must be owner of relation USER_ACCOUNT_ID_seq

asked Feb 5, 2014 at 14:22

3 votes

3 answers

6k views

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

asked Jul 17, 2018 at 13:44

3 votes

1 answer

3k views

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

asked Feb 14, 2012 at 20:50

2 votes

1 answer

10k views

How to generate time in milliseconds in PostgreSQL stored procedure?

asked Feb 1, 2014 at 10:57

2 votes

2 answers

2k views

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

asked Apr 11, 2012 at 13:43

2 votes

1 answer

742 views

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

asked Mar 3, 2012 at 17:57

2 votes

1 answer

633 views

How to perform asynchronous cascade slave replication of PostgreSQL database?

asked Nov 27, 2011 at 5:03

2 votes

1 answer

3k views

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

asked Mar 28, 2014 at 20:11

1 vote

1 answer

2k views

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

asked Jul 19, 2014 at 8:41

1 vote

1 answer

319 views

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

asked Apr 24, 2012 at 22:16

0 votes

1 answer

259 views

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

asked Sep 13, 2014 at 13:56

0 votes

1 answer

2k views

How to update array fields in a table in Postgresql?

asked May 20, 2015 at 15:42

0 votes

1 answer

465 views

Azure automatic fail-over vs always on availability groups clarification

asked Jan 2, 2019 at 12:31