On 13 April 2010 05:31, raghavendra t wrote:
> Hi All,
>
> Could please guide me in knowing the Dynamic Catalog views which will tell
> about the Buffers and Cache information using System Catalogs.
Look at pg_buffercache contrib.
http://www.postgresql.org/docs/8.4/interactive/pgbuffercache.html
Clemens Eisserer writes:
> Is there anything I can do to lower the size of those two files?
Well, if you were using 8.4 you could fool with configure's
--with-wal-segsize option. Since you're not, look into
src/include/pg_config_manual.h. In either case, expect to do a
full recompile and initdb
jimmy Zhang wrote:
VTD-XML 2.8 has been released. Please
visit https://sourceforge.net/projects/vtd-xml/files/ to download the
latest version.
* Expansion of ...
Is a postgresql contributed module available or underway?
--
Sent via pgsql-general mailing list (pgsql-genera
raghavendra t wrote:
Hi All,
Could please guide me in knowing the Dynamic Catalog views which will
tell about the Buffers and Cache information using System Catalogs.
you mean, stuff like
http://www.postgresql.org/docs/current/static/catalog-pg-statistic.html ?
afaik, data about whats i
VTD-XML 2.8 has been released. Please visit
https://sourceforge.net/projects/vtd-xml/files/ to download the latest version.
a.. Expansion of Core VTD-XML API
a.. VTDGen adds support for capturing white spaces
b.. VTDNav adds support for suport for getContentFragment(), recoverNode()
Hi All,
Could please guide me in knowing the Dynamic Catalog views which will tell
about the Buffers and Cache information using System Catalogs.
Thanks in Advance
Regards
Raghavendra
On 12/04/10 17:52, Ben Martin wrote:
A few things I do with the SQLite engine are analysing apache log files,
or other separated files (like running awk with SQL as the query
language), and interacting with web services as a table, eg, selecting
data from a google spreadsheet and a local sqlite
Tom Lane wrote:
> Glyn Astill writes:
> > But I do remember there was a set of libs called ixemul
> > (http://aminet.net/package/dev/gg/ixemul-bin) that a lot of people used to
> > port unix apps to the Amiga with, probably not enough to port postgres
> > though.
>
> Ah, I wondered if there mi
Alban Hertroys wrote:
I have to say I was a bit surprised to find that .pgpass files store those
passwords as plain text though. Some method like ssh uses with public and
private keys would be an improvement IMO. Especially since we can choose to use
password encryption over the wire.
Storing
Magnus Hagander wrote:
> 2010/4/1 Christophe Dore :
> >
> > - is there any configuration that can be done on server side to prevent
> > the client side to use such file to read passwords ?
>
> No. It happens before the user ha slogged in, obviously.
>
>
> > - is there any options that can be set
Clemens Eisserer wrote on 12.04.2010 23:25:
Hi,
I am using postgres-8.3 on an embedded ARM9 system.
Works pretty well, except for stoarge consumptions.
The actual table data is rather small, but postgres creates 2 16mb
files in pg_xlog:
r...@mesrv:/var/lib/postgresql/8.3/main# ls -la pg_xlog/
t
Hi,
I am using postgres-8.3 on an embedded ARM9 system.
Works pretty well, except for stoarge consumptions.
The actual table data is rather small, but postgres creates 2 16mb
files in pg_xlog:
r...@mesrv:/var/lib/postgresql/8.3/main# ls -la pg_xlog/
total 32820
-rw--- 1 postgres postgres 167
On Apr 12, 2010, at 11:31 AM, Scott Marlowe wrote:
> On Mon, Apr 12, 2010 at 12:22 PM, A B wrote:
>> Hello!
>>
>> I have a table (think of it as a table of log messages)
>>
>> time | message
>> ---
>> 1 | a
>> 2 | b
>> 3 | b
>> 4 | b
>> 5 |
On 12 April 2010 22:22, A B wrote:
>
> first | message | last | count
> --
> 1 | a | 1 | 1
> 2 | b | 4 | 3 <--- here it squeezes
> similar consecutive messages into a single row
> 5 | a
On Mon, Apr 12, 2010 at 12:22 PM, A B wrote:
> Hello!
>
> I have a table (think of it as a table of log messages)
>
> time | message
> ---
> 1 | a
> 2 | b
> 3 | b
> 4 | b
> 5 | a
>
> the three 'b' are the same message, so I would like to write
On Thu, Apr 1, 2010 at 2:41 PM, Brad Nicholson wrote:
> Hi,
>
> Is anyone using Lifekeeper for Linux availability with Postgres?
>
> If so, what are your thoughts on it? Work as advertised? Any dangerous
> gotchas?
>
> I have a lot of customers using it. The latest version fixes the issue
that
Hello!
I have a table (think of it as a table of log messages)
time | message
---
1 | a
2 | b
3 | b
4 | b
5 | a
the three 'b' are the same message, so I would like to write a query
that would give me a result that is similar to what the unix
Hello,
I'm sorry, because this may be a simple question: I'm programming a C
function that returns a set (PostgreSQL 8.4). The function crash, and
I'm trying to
debug it. I've read:
http://www.postgresql.org/docs/8.4/interactive/xfunc-c.html
http://www.postgresql.org/docs/8.4/interactive/error-me
Hi Merlin, hi Alban,
thank you both for your helpful answers. Now, I splitted the function
into smaller parts which have to be called seperately one after another.
Probably, I will write a script for calling all the functions needed.
Not as nice as an all in one function, but if there is no other
On 12/04/10 17:58, Vikram A wrote:
Thank you for the valuable reply.
If i go for the path store rather than the bytea. The disk sever [where
files are stored] must be live always?
Well, if it's down or inaccessible then so are your files, but it won't
stop the database its self from working.
Thank you for the valuable reply.
If i go for the path store rather than the bytea. The disk sever [where files
are stored] must be live always?
Is it possible to keep the DB and the files on the same server for avoiding the
n/w failure. Is it good to have NFS on red hat linux enterprise edit
On Mon, 2010-04-12 at 13:15 +0800, Craig Ringer wrote:
> On 12/04/10 11:34, Ben Martin wrote:
>
> >In my SQLite vtable both of the above restrictions don't apply. To
> > mitigate (1) I was hopeful that there was a way to get the connection to
> > PG on the server to fork/setuid
>
> The pg ba
On 12/04/10 17:17, Vikram A wrote:
Hi,
I would like to store the files(.doc, .xls , images, vedios) in the
postgresql data base as a field.
If you really want to store them in the database your options are a
bytea field (warning: size limits) or a large object. See the manual.
Do you really
Hi,
I would like to store the files(.doc, .xls , images, vedios) in the postgresql
data base as a field.
Is postgres is supporting such kind of activities? Or In what way i can do so?
Please guide me.
Thank you in advance,
Vikram A
24 matches
Mail list logo
