Re: [SQL] Efficiency Problem

From: Surfing Sent: 17/03/2013 12:16 To: pgsql-sql@postgresql.org <mailto:pgsql-sql@postgresql.org> Subject: [SQL] Efficiency Problem Hi all, I'm composing a query from a web application of type: *SELECT * FROM

[SQL] Efficiency Problem

Hi all, I'm composing a query from a web application of type: *SELECT * FROM table WHERE a_text_field LIKE replace_something ('%**/a_given_string/**%');* The function replace_something( ... ) is a stored procedure that replaces some particular characters with others. The problem is that I

[SQL] Euclidean distance between two sets of tuples

Hi all, I would like to ask if there exists a function to calculate the Euclidean distance between two rows of the same table. Obviously, the distance between two non-numeric fields should be 0 if they are the same value, 1 otherwise. In general, I need to compute an average distance betwe

[SQL] Function to total reset a schema

Hi all, I need to write a function that totally empty a schema. So I have written a TRUNCATE statement for each table and set to 0 each sequence. Btw, it could be good to execute a vacuum statement on each table, but from within the function this is not allowed. Is there a way to obtain the s

Re: [SQL] Function to total reset a schema

tables it is faster. Furthermore, it reclaims disk space immediately, rather than requiring a subsequent VACUUM operation. This is most useful on large tables." So the VACUUM should not really be necessary..thanks. Il 29/05/2011 09:54, Thomas Kellerer ha scritto: Surfing wrote on 29.05.2011

[SQL] Function to total reset a schema

Hi all, I need to write a function that totally empty a schema. So I have written a TRUNCATE statement for each table and set to 0 each sequence. Btw, it could be good to execute a vacuum statement on each table, but from within the function this is not allowed. Is there a way to obtain the s