4,233 reputation
11427
bio website
location Chicago, IL
age
visits member for 2 years, 10 months
seen 3 hours ago

Developer


Oct
7
awarded  Taxonomist
Aug
25
awarded  Notable Question
Aug
13
revised Understanding pg-pool in details
edited title
Aug
13
answered PostgreSQL: Trigger for updating view doesn't work
Aug
11
comment PosgreSQL: very slow select on a single table with no joins
Sending a result set over the network and rendering it on the client takes time. Instead of SELECT * FROM, try running SELECT SUM(LENGTH(id)) FROM - that might run faster.
Aug
7
awarded  Popular Question
Jul
26
awarded  Custodian
Jul
26
reviewed Approve suggested edit on Database Design Help: MySql/PostgreSQL Single Database/Multiple Databases
Jul
25
comment Filling in missing dates in record set from generate_series()
to get more than 1 as count, add more test data.
Jul
25
comment Filling in missing dates in record set from generate_series()
@Mr.Concolato The previous version worked on 9.3. Fixed.
Jul
25
revised Filling in missing dates in record set from generate_series()
deleted 27 characters in body
Jul
25
answered Filling in missing dates in record set from generate_series()
Jul
25
accepted Should I shrink my database?
Jul
25
revised Should I shrink my database?
added 252 characters in body
Jul
24
comment Should I shrink my database?
Thank you for the links, but I am not sure they are completely relevant: they mostly assume that the data is going to grow back, such as "Do you ever shrink your data files? I’ve personally never been fond of it, especially for production databases. After all, they’ll simply have to grow again". This is not the case, they will not have to grow again.
Jul
24
revised Should I shrink my database?
added 102 characters in body
Jul
24
comment Should I shrink my database?
Regarding "You really need to find out at what pace it is growing" - I did. "Think about it - what are you going to do with the disk space that you gain from shrinking the database " - I already thought about it. I modified my question accordingly.
Jul
24
revised Should I shrink my database?
added 465 characters in body
Jul
24
asked Should I shrink my database?
Jul
22
awarded  Nice Question