subject:"\[GENERAL\] Query Questions \- PostgreSQL"

Re: [GENERAL] Query Questions - PostgreSQL

2016-01-14 Thread Saulo Merlo

On 13/01/2016, at 3:30 PM, Saulo Merlo wrote: So.. I have a Query that is taking too long to complete. OLD QUERY: SELECT file.inode_idAS file_id, file.parent_inode_id AS file_group, file.relative_path AS file_type, file.file_data AS file_binary,

Re: [GENERAL] Query Questions - PostgreSQL

2016-01-13 Thread Saulo Merlo

Anyone who can help with this please? Thanks Sent from my phone > On 13/01/2016, at 3:30 PM, Saulo Merlo wrote: > > So.. I have a Query that is taking too long to complete. > > OLD QUERY: > >> SELECT > >> file.inode_idAS file_id, > >>

[GENERAL] Query Questions - PostgreSQL

2016-01-12 Thread Saulo Merlo

So.. I have a Query that is taking too long to complete. OLD QUERY: SELECT file.inode_idAS file_id, file.parent_inode_id AS file_group, file.relative_path AS file_type, file.file_data AS file_binary, file.node_full_path AS file_name, file.last_modified AS