Kevin Grittner writes:
> Raymond C. Rodgers wrote:
>> As I went to add a tsvector column, it occurred to me that it
>> might be possible to add a dynamic tsvector column through the
>> use of a view, so I created a temporary view with a command along
>> the lines of:
>>
>> CREATE TEMPORARY
On 02/22/2013 06:27 PM, Jeff Janes wrote:
On Fri, Feb 22, 2013 at 5:57 AM, Stefan Andreatta
mailto:s.andrea...@synedra.com>> wrote:
Hi,
If I understand
http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html
correctly, the autovacuum threshold in could be estimated lik
On Saturday, February 23, 2013, Stefan Andreatta wrote:
>
>
> Thanks Jeff, that helped a lot (as did a careful rereading of
> http://www.postgresql.org/docs/9.1/static/monitoring-stats.html and
> http://www.postgresql.org/docs/9.1/static/catalog-pg-class.html ;-)
>
> However, to estimate whether a
On 02/23/2013 05:10 PM, Jeff Janes wrote:
On Saturday, February 23, 2013, Stefan Andreatta wrote:
Thanks Jeff, that helped a lot (as did a careful rereading of
http://www.postgresql.org/docs/9.1/static/monitoring-stats.html
and
http://www.postgresql.org/docs/9.1/static/catalo
On 02/23/2013 05:26 AM, Tom Lane wrote:
A "virtual" tsvector like that is probably going to be useless for
searching as soon as you get a meaningful amount of data, because the
only way the DB can implement a search is to compute the tsvector
value for each table row and then examine it for the
Hi, I would like to learn about how stored procedures are handled in postgres.
In particular, I'd like to learn how plpgsql procedures are compiled and
stored, and how they (both plpgsql and C procedures) interact with the
optimizer during planning. Would appreciate if someone can point out so
On 02/23/2013 02:49 PM, Derek Perak wrote:
Hi, I would like to learn about how stored procedures are handled in
postgres. In particular, I'd like to learn how plpgsql procedures are
compiled and stored, and how they (both plpgsql and C procedures)
interact with the optimizer during planning. Woul
I still can't access my SSL enabled server!!!
Is root.crt supposed to be an exact copy of server.crt file which I use in my
client's keystore?
I have another observation. As I start the coordinator node, I don't see any
file access to the server.key or server.crt file? Aren't these files supp
On 2013-02-23, Raymond C. Rodgers wrote:
> On 02/23/2013 05:26 AM, Tom Lane wrote:
>> A "virtual" tsvector like that is probably going to be useless for
>> searching as soon as you get a meaningful amount of data, because the
>> only way the DB can implement a search is to compute the tsvector
