1,011 reputation
315
bio website localhost.localdomain
location Minnesota, USA
age 93
visits member for 3 years, 2 months
seen 21 hours ago

Linux, perl, postgresql, oracle. Other tools as needed.


Sep
11
awarded  Critic
Aug
27
awarded  Yearling
Aug
11
comment PosgreSQL: very slow select on a single table with no joins
What does select pg_relation_size('data'); look like?
Jul
29
comment Checking whether two tables have identical content in PostgreSQL
@Faheem Mitha -- that is correct
Jul
29
answered Checking whether two tables have identical content in PostgreSQL
Mar
23
answered How to make up sqlplus login automatically execute a script for Oracle in Linux?
Nov
20
awarded  Informed
Oct
15
comment What is Required to use Oracle Performance Manager to monitor SQL Server?
While not an answer to the question as stated, confio.com has a tool that does performance monitoring for Oracle, SQL Server, DB2, and Sybase databases. I test drove it a while back and it might do all that you are looking for.
Aug
27
awarded  Yearling
Aug
26
answered in-memory SQL database system
Aug
14
awarded  Popular Question
Jul
2
answered What are the valid formats of a PostgreSQL schema name?
May
22
awarded  Caucus
May
3
answered Daily and Differential Backups
Apr
12
answered Why are constraints applied in the database rather than the code?
Mar
20
comment What is a good way to determine the performance I should expect from a PostgreSQL server?
Juan-- Take a look at packtpub.com/postgresql-90-high-performance/book
Mar
19
answered get account activity in postgresql
Mar
19
comment Very slow DELETE in PostgreSQL, workaround?
Are there indexes on the foreign key columns of the child tables? I haven't tested it with postgresql, but with some databases (cough oracle cough) that can make a huge difference.
Mar
14
comment How do I remove duplicate records in a join table in PostgreSQL?
@marcamillion -- tid == "tuple id", not sure what the c means.
Mar
14
comment How do I remove duplicate records in a join table in PostgreSQL?
++ for the exists solution. Much better than my suggestion.