meta user
network profile
| bio | website | xn--vod-0ma.blogspot.com |
|---|---|---|
| location | Orsay, France | |
| age | 36 | |
| visits | member for | 10 months |
| seen | Jun 2 at 16:47 | |
| stats | profile views | 27 |
Everyday experience: - C++ - Python - C - C# - Xaml - Xml - Xslt - Xschema - XPath - Regex - Sql - VB
Used to: - Win32 - Mfc - Com/Atl - Stl - Design Patterns - MsXml - Wpf
At ease with: - Html - Java - Soap
Practicing intensively: - C++11 - Javascript - Css - Http - Boost C++
Learning/Tried/Discovering/Culture: - C++/Cli - F# - Oz - Haskell - Perl - Prolog - Pict and Nomadic Pict
Interested in: - Design Patterns - Web Design - Lambda Calculus - Pi Calculus - Language design - Artificial Intelligence - Digital Signal Processing - Categorial logic - Test Driven Development
|
Jun 17 |
awarded | Popular Question |
|
May 21 |
awarded | Popular Question |
|
May 20 |
awarded | Constituent |
|
May 13 |
awarded | Caucus |
|
Apr 16 |
suggested | suggested edit on PostgreSQL concurrent increment of counter |
|
Apr 15 |
revised |
How to change the data directory on Postgresql 9.1 on Ubuntu highlight code |
|
Apr 15 |
revised |
How to change the data directory on Postgresql 9.1 on Ubuntu deleted 13 characters in body |
|
Apr 15 |
answered | How to change the data directory on Postgresql 9.1 on Ubuntu |
|
Apr 15 |
suggested | suggested edit on How to change the data directory on Postgresql 9.1 on Ubuntu |
|
Apr 10 |
comment |
Optimizing queries on a range of timestamps (two columns) the tsrange type really recovers the data I want to encode. It's only with your explication that I grasped that the database had no idea of the relative order between the two different timestamp column. I'll welcome 9.2. |
|
Apr 10 |
comment |
Optimizing queries on a range of timestamps (two columns) I have to let finish the big bulk copy generated from the intensively awkward query of mine, so making the process really slow, it was turning for hours before I asked the question. But I have calculated, and I decided to let it turn until tomorow morning, it'll be finished, and the new table ready to be filled tomorow. I have tried to create your index concurrently during the job, but due to too much access(i think), the creation of the index should be locked. I'll repeat this same test time again tomorow with your solution. I have also looked at how upgrading to 9.2 ;-) for debian/ubuntu. |
|
Apr 10 |
comment |
Optimizing queries on a range of timestamps (two columns) I should tell this at least only once, that each of your answers on SO and DBA are of really high added value/exprertise, and most of the time the most complete. Just to say it once: Rescpect!. |
|
Apr 10 |
accepted | Optimizing queries on a range of timestamps (two columns) |
|
Apr 9 |
comment |
Optimizing queries on a range of timestamps (two columns) well it is 45s. I don't know why it says 45ms. I wouldn't even start complaining if that was as fast as 45ms... :-) Maybe a bug in the output of explain analyze. Or maybe it's the time of the analyze to perform. Dunno. But 40/50 seconds is what I measure. |
|
Apr 9 |
comment |
Optimizing queries on a range of timestamps (two columns) I already have both index. Except the primary key is the other, but the index you propose already exists, and is the one that is used if you look at the explain: Bitmap Index Scan on idx_time_limits_phi_start_end |
|
Apr 9 |
revised |
Optimizing queries on a range of timestamps (two columns) edited title |
|
Apr 9 |
revised |
Optimizing queries on a range of timestamps (two columns) added 1 characters in body |
|
Apr 9 |
revised |
Optimizing queries on a range of timestamps (two columns) added 16 characters in body |
|
Apr 9 |
asked | Optimizing queries on a range of timestamps (two columns) |
|
Apr 9 |
revised |
POSTGRES DB Server Blunder remove noise and signature |
