peterh's user avatar
peterh's user avatar
peterh's user avatar
peterh
  • Member for 10 years, 3 months
  • Last seen this week
34 votes
Accepted

Drop table taking too long

22 votes

Can CURRENT_TIMESTAMP be used as a PRIMARY KEY?

6 votes

How do I find out how far along my PostgreSQL query is?

4 votes

Trying to connect a PostgreSQL database to Eclipse

4 votes
Accepted

How to improve the performance of this select query?

4 votes

How to update integer primary key adding 1000?

3 votes
Accepted

How to make sqlplus prompt longer than 50 chars?

3 votes
Accepted

How to make a table that could add many same number of different item?

2 votes
Accepted

recover postgresql database after removal with --purge

2 votes

Missing mysqld.sock file on linux server

2 votes

How to build the database for subdomain multisite?

2 votes

If a database only ever has one insert, is it bad to index every possible column combination?

2 votes

How to filter for consecuting timeline events in pure SQL?

2 votes
Accepted

How does SQL*Plus connect to Oracle without a listener?

2 votes

MySQL CPU usage super high since server crashed

2 votes

Relations between a imeid, sim chip, and account from a cellphone company?

2 votes

Postgresql create database with size & resize?

1 vote

Docker for Oracle Timestamp out of sync

1 vote

How to synchronize a Windows database for Linux?

1 vote

Creating a database structure for a quiz

1 vote
Accepted

How to change the output encoding of Oracle command line tools to UTF8?

1 vote

pgAdmin on a fresh OS X Server installation

0 votes

MySQL database configuration for fastening the select and insert queries

0 votes

Keywords - column or separate table

0 votes

When trying to connect to an external postgres database using pgAdmin, I get an error

0 votes

How to optimize and find minimum from the two sql query, by writing it as single query?

0 votes
Accepted

Database Design where there's three parent tables and only 1 child table

0 votes
Accepted

How to store array values?

0 votes

Significantly Slower DB Dumps on AWS RDS After Turning on Encryption?

0 votes

How to recover data from a corrupted /base/ directory?