Re: [GENERAL] :Posgres - performance problem

2015-03-25 Thread lucas.g...@gmail.com
I'm not an expert either, but your data model sounds very broken as well... I guess it's possible that each query would need all 417 columns but it seems unlikely... If that were normalized into 'n' tables then each query would be returning a whole lot less data... I've never heard of a database

Re: [GENERAL] :Posgres - performance problem

2015-03-25 Thread lucas.g...@gmail.com
"I need gather data into one table for consistency and easy for export and import, it's ok if I split data to smaller tables, but when export/import/update, i must excute query on alot of table. And this way lead data to inconsistency if I forget update/export/import on 1 or more table. It is terri

[GENERAL] Question regarding log files in postgresql

2014-07-21 Thread lucas.g...@gmail.com
I've rolled postgres to 'production', so box is in prod, but the applications aren't active yet. When I rolled the new box I'm seeing 2 log files: postgresql--MM-dd_hhmmss.log AND postgresql-9.3-main.log The 'main' log doesn't appear to be used, however the time stamped file is. Does this m

Re: [GENERAL] Question regarding log files in postgresql

2014-07-22 Thread lucas.g...@gmail.com
wrote: > On 07/21/2014 02:21 PM, lucas.g...@gmail.com wrote: > >> >> >> I've rolled postgres to 'production', so box is in prod, but the >> applications aren't active yet. >> >> When I rolled the new box I'm seeing 2 log files: &