On Mon, Apr 25, 2016 at 03:18:30PM +1000, da...@andl.org wrote:
> It seems to me that it should be possible to create a language front
> end for Andl by creating a background worker and a language handler.
I've been reading your posts over the past few days and while I find it
fun to follow, I
ational SQL database, version
> 9.1
> ii postgresql-9.2 9.2.15-1.pgdg1 object-relational SQL database, version
> 9.2
>
> Does this mean it is removed?
>
> On 24/03/2016 17:34, David Wilson wrote:
> >Hi Howard,
> >
> >So long as you haven't touched anything else, simpl
Hi Howard,
So long as you haven't touched anything else, simply reinstalling the
package should restore your cluster. Debian packages only do
initialization if the data directories are missing.
David
On Thu, Mar 24, 2016 at 05:29:23PM +, Howard News wrote:
> Hi,
>
> I uninstalled the
On Wed, Dec 23, 2015 at 07:07:31AM -0600, oleg yusim wrote:
> May we run into situation, when attacker dumps memory and analyses it
> for valuable content, instead of reserving it for own process, where
> it would be zeroed? My understanding, it is a possibility. Does kernel
> have any safeguard
On Tue, Dec 22, 2015 at 04:52:23PM -0600, oleg yusim wrote:
> Greetings,
>
> I'm looking at the following security control right now:
>
> The DBMS must prevent unauthorized and unintended information transfer via
> shared system resources.
>
> The purpose of this control is to prevent
On Wed, Oct 27, 2010 at 5:02 PM, Michael Clark codingni...@gmail.comwrote:
while ( ((consume_result = PQconsumeInput(self.db)) == 1)
((is_busy_result = PQisBusy(self.db)) == 1) )
;
The problem with this code is that it's effectively useless as a test.
You're just spinning in a
List-
I've got a calculation that, due to its use of exp(), is produces double
precision intermediate results which I ultimately need to cast back to real
to store in a table column. However, with certain inputs, this results in an
underflow error. Is there any way outside of an
On Wed, Sep 22, 2010 at 8:30 PM, Adrian Klaver adrian.kla...@gmail.comwrote:
From here;
http://www.postgresql.org/docs/8.4/interactive/datatype-boolean.html
I believe the question relates to changing the string *output* of the
database to something other than 't' and 'f', not an issue with
On Wed, Sep 15, 2010 at 1:36 PM, Carlos Mennens carlos.menn...@gmail.comwrote:
Thanks but then I am confused why I am getting the following:
You initially connected to the postgres database because you were logging in
as the postgres user...
postgres=# \d
No relations found.
postgres=#
On Mon, Jun 14, 2010 at 5:24 AM, Leonardo F m_li...@yahoo.it wrote:
For inserts I do not see the reason
why
it would be better to use index partitioning because AFAIK
b-tree
would behave exactly the same in both cases.
no, when the index gets very big inserting random values gets
On Mon, Jun 14, 2010 at 8:38 AM, Peter Hunsberger
peter.hunsber...@gmail.com wrote:
Can you define acceptable? IIRC the OP is looking for 20,000+ inserts /
sec.
He's actually only looking for 2k inserts/sec. With a battery backed
controller I can sustain that, yes. That's also on
On Wed, May 26, 2010 at 4:29 PM, John Gage jsmg...@numericable.fr wrote:
Please forgive this intrusion, and please ignore it, but how many
applications out there have 110,000,000 row tables? I recently multiplied
85,000 by 1,400 and said now way Jose.
I've got a DB with two 500,000,000+ row
On Thu, Oct 1, 2009 at 10:04 PM, Chris dmag...@gmail.com wrote:
Tim Uckun wrote:
If this is a common query you could probably do a multi-column index on all
3 columns (id, company_id, source_model_name) - but if company_id and
source_model_name have a low number of distinct values, then it's
On Thu, Oct 1, 2009 at 10:21 PM, Tim Uckun timuc...@gmail.com wrote:
Interesting. I would have thought the order of the fields would not
matter. I don't have to rewrite the query do I?
No. For multi-column indices, however, postgres can, starting at the
leftmost in the index, use as many
On Tue, Aug 11, 2009 at 3:35 AM, Juan Backsonjuanback...@gmail.com wrote:
PGRES_COMMAND_OK
You want PGRES_TUPLES_OK for a select statement. You're not getting an
actual failure- you're checking for the wrong status.
--
- David T. Wilson
david.t.wil...@gmail.com
--
Sent via pgsql-general
On Mon, Jul 27, 2009 at 7:52 PM, Janet Jacobsenjsjacob...@lbl.gov wrote:
Can you suggest other strategies?
Something that might be easier to play with is to create a (or
several, to speed up other queries) functional index on the comparison
between rbscore and the cutoff. It won't buy you
On Mon, Jul 27, 2009 at 8:24 PM, Greg Starkgsst...@mit.edu wrote:
I think it would be even more interesting to have partial indexes --
ie specified with WHERE rbscore cutoff.
Yes- that's what I actually meant. Word got scrambled between brain
and fingers...
--
- David T. Wilson
On Tue, Jul 14, 2009 at 7:47 PM, Jim Michaelsjmich...@yahoo.com wrote:
could somebody rewrite pg_dumpall and pg_dump so that it makes editable
dumps?
most programmer's text editors can't handle more than 2000 characters per
line.
and I want to be able to edit my dumps.
You're going to have
On Wed, Jun 24, 2009 at 12:48 AM, Scott Marlowescott.marl...@gmail.com wrote:
Maybe. Rows that are updated often are NOT generally pgsql's strong
suit, but IF you're running 8.3 or above, and IF you have a low enough
fill factor that there's empty space for the updates and IF the fields
you
On Mon, Jun 15, 2009 at 2:23 PM, Mike Toewsmwto...@sfu.ca wrote:
Hi,
I'm having difficulty constructing a query that will find breaks where data
change in a time-series. I've done some searching for this too, but I
haven't found anything.
Here is my example situation, consider my source
On Mon, Jun 8, 2009 at 11:04 AM, BlackMage dsd7...@uncw.edu wrote:
Is there a field that can actually store time in PostgreSql. And what I mean
by time is not like time of the day, but a specific amount of time.
The manual is your friend:
On Wed, May 20, 2009 at 4:41 PM, Sergey Samokhin prikru...@gmail.com wrote:
Is there a way to do #1 (it's a bit cleaner and simpler to implement)?
You could wrap the whole thing in a transaction. If you don't get to
the commit, the whole transaction should roll back.
--
- David T. Wilson
On Mon, May 18, 2009 at 3:13 PM, Joshua Berry yob...@gmail.com wrote:
Any hints/tips? Is our original solution okay, or is there something we can
do to improve things?
It seems as if you don't really care about the results of the query-
just whether or not it returns any rows. In that case, why
On Mon, Apr 20, 2009 at 7:39 PM, jc_mich juan.mich...@paasel.com wrote:
You've understood very well my problem, but also this query works as worse
than everything I did before, it throws as many rows as rows are contained
my tables clients and stores. I only want to find for every client what
On Wed, Apr 8, 2009 at 12:24 PM, Jennifer Trey jennifer.t...@gmail.com wrote:
I think I might have misunderstood the effective cache size. Its measured in
8kB blocks. So the old number 449697 equals 3.5 GB, which is quite much.
Should I lower this? I had plans to use 2.75GB max. Can I put
On Tue, Mar 31, 2009 at 9:18 PM, Aleksey Tsalolikhin
atsaloli.t...@gmail.com wrote:
Could not create directory '/home/postgres/.ssh'.
Host key verification failed.
Have you tested ssh node2 as the postgres user with SELinux enabled?
This looks like ssh failing to access the .ssh directory
On Mon, Mar 23, 2009 at 3:07 AM, Scott Marlowe scott.marl...@gmail.com wrote:
Are you saying pg_quer_params is MORE effective than pg_escape_string
at deflecting SQL injection attacks?
pg_query_params() will protect non-strings. For instance, read a
number in from user input and do something
On Wed, Feb 18, 2009 at 9:47 AM, Joey Morris rjmorri...@gmail.com wrote:
I expected this program to print connecting, but in fact I get no output
whatsoever. If I comment out the PQconnectdb and PQfinish lines, I see
connecting as expected. What could be going on here?
Try adding
On Fri, Jan 16, 2009 at 3:27 PM, Jason Long
mailing.l...@supernovasoftware.com wrote:
I just tried it by sending text only instead of text and html. We will see
if it goes through this time.
Other than that do you see anything weird about my email?
Still nothing. Do you have webspace you
On Sat, Jan 3, 2009 at 5:59 PM, Jolles, Peter M (GE Infra, Energy)
peter.jol...@ge.com wrote:
For example, on these days, 4/7/02 2:00 AM imports to 4/7/02 3:00 AM.
4/6/03 2:15 AM imports as 4/6/03 3:15 AM, etc. All other dates and times
do not give any errors. I have tried to extract the date
On Sat, Nov 22, 2008 at 4:54 PM, Ciprian Dorin Craciun
[EMAIL PROTECTED] wrote:
On Sat, Nov 22, 2008 at 11:51 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
On Sat, Nov 22, 2008 at 2:37 PM, Ciprian Dorin Craciun
[EMAIL PROTECTED] wrote:
Hello all!
SNIP
So I would conclude that relational
On Thu, Nov 13, 2008 at 2:03 PM, [EMAIL PROTECTED] wrote:
I have several tables that when I run VACUUM FULL on, they are under 200k,
but after a day of records getting added they grow to 10 to 20 megabytes.
They get new inserts and a small number of deletes and updates.
seq_scan |
On Tue, Nov 4, 2008 at 2:12 PM, Webb Sprague [EMAIL PROTECTED] wrote:
Can't do that. (Or I wouldn't have asked the question.) Need a WWW
interface, period.
A WWW interface doesn't preclude the suggestion of simply relying on
permissions to maintain safety and providing what amounts to a
On Tue, Oct 28, 2008 at 7:10 PM, Christophe [EMAIL PROTECTED] wrote:
On Oct 28, 2008, at 4:03 PM, Steve Atkins wrote:
Installing from source means I can avoid the fragility of macports or
fink, and know that I've built it in much the same way as the postgresql or
solaris installation I'd be
After dropping an index to do some full-table updating, I'm running
into an out of memory issue recreating one of my indices. This is on
8.3 running on linux.
The table in question has about 300m rows. The index is on a single
integer column. There are approximately 4000 unique values among the
On Mon, Oct 13, 2008 at 6:44 AM, Gregory Stark [EMAIL PROTECTED] wrote:
How much memory the OS allows Postgres to allocate will depend on a lot of
external factors. At a guess you had some other services or queries running at
the same time the first time which reduced the available memory.
On Thu, Oct 9, 2008 at 1:48 PM, Bill Thoen [EMAIL PROTECTED] wrote:
No, this won't work. Here's an example of my tables:
Table1
1, 12, A
2, 16, B
8, 6, A
19, 9, C
Table2
1, 13, D
2, 16, B
8, 6, B
12, 5, A
select * from table1
union
select table2.* from table2 left join table1 on
On Thu, Oct 9, 2008 at 3:31 PM, Bill Thoen [EMAIL PROTECTED] wrote:
Thanks, but that didn't work. That selected only the records from table1.
That's why I warned you about it being written in gmail. :)
select * from table1
union
select table2.* from table2 left join table1 on table2.a=table1.a
On Tue, Oct 7, 2008 at 7:30 PM, Saptarshi Guha [EMAIL PROTECTED] wrote:
Q: How efficient is this?
If connectionHash is unique or near to it, and everything's indexed...
it could work for reasonable K values depending on your performance
requirements.
Every time i create a new table should i
On Thu, Sep 11, 2008 at 3:19 PM, Markova, Nina [EMAIL PROTECTED] wrote:
Is there a psql or other command that I can use to list tables and their
rows? All I found is this:
http://archives.postgresql.org/pgsql-hackers/2004-09/msg00876.php
select tablename,reltuples from pg_class inner join
On Fri, Sep 5, 2008 at 2:52 AM, Subspace god [EMAIL PROTECTED] wrote:
The following does not work in C++, executed as above, in another session
using two subsequent calls to PQexecParams
PREPARE myquery (text) AS INSERT INTO myTable (word) VALUES ($1);
EXECUTE myquery($1::text);
You're
On Fri, Aug 15, 2008 at 11:42 PM, Amber [EMAIL PROTECTED] wrote:
Dear all:
We are currently considering using PostgreSQL to host a read only
warehouse, we would like to get some experiences, best practices and
performance metrics from the user community, following is the question list:
On Mon, Aug 4, 2008 at 2:08 PM, Rajarshi Guha [EMAIL PROTECTED] wrote:
select count(aid) where cid = 123 and cid = 456;
but I was wondering whether I could construct a single SQL statement to do
this.
Any pointers would be appreciated,
Typed into gmail, so may need some tweaking, but
On Fri, Aug 1, 2008 at 10:16 AM, Ivan Sergio Borgonovo
[EMAIL PROTECTED] wrote:
what's the use of column in the COPY FROM syntax if I get:
ERROR: extra data after last expected column
I've read:
http://bytes.com/forum/thread424089.html
but then... is there any actual use?
I use COPY
On Fri, Aug 1, 2008 at 4:07 PM, Alex Vinogradovs
[EMAIL PROTECTED] wrote:
By loading in bulks, I mean I load some 40-50 thousand
rows at once into a table that already has some millions.
Index rebuild on that table after each 50k inserts will
be even less efficient ;)
How many indexes do you
On Fri, Aug 1, 2008 at 4:16 PM, David Wilson [EMAIL PROTECTED] wrote:
On Fri, Aug 1, 2008 at 4:07 PM, Alex Vinogradovs
[EMAIL PROTECTED] wrote:
By loading in bulks, I mean I load some 40-50 thousand
rows at once into a table that already has some millions.
Index rebuild on that table after
On Tue, Jul 29, 2008 at 5:42 PM, Bob Pawley [EMAIL PROTECTED] wrote:
begin
Don't you need a ; after your begin...?
--
- David T. Wilson
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
My application is adding a bytea column to a table into which data is
dumped in approximately 4k row batches, one batch approximately every
10 seconds. To this point, those dumps have used copy from stdin;
however, I'm having some difficulty getting bytea encodings to work
with it. Specifically, I
On Mon, Jul 28, 2008 at 1:24 AM, Klint Gore [EMAIL PROTECTED] wrote:
Try just a single \
e.g.
ge.xls,application/vnd.ms-excel,71168,\320\317\021\340\241[snip]
Thanks- I did try that, and it at least gave the expected output from
select, but is there a way to verify that it's actually handling
On Thu, Jun 19, 2008 at 7:54 AM, Steve Clark [EMAIL PROTECTED] wrote:
I am not sure that will do what I want. As an example
suppose I have 5 rows and the idfield is 1,2,3,4,5
now row 1 is updated, not the idfield but another column, then row 3 is
deleted.
Now I would like to renumber them
On Wed, Jun 11, 2008 at 5:54 PM, David Lambert [EMAIL PROTECTED] wrote:
I am trying to find a way to figure out what offset I would have to use in a
SELECT with LIMIT and OFFSET clauses to get a grouping of records. For
example:
Consider a table full of first names. I want to be able to
On Tue, May 13, 2008 at 5:43 PM, Nathan Thatcher [EMAIL PROTECTED] wrote:
Is this the correct way to do this, or is there a better way / a way
to get PostgreSQL to recognize an alias in the HAVING clause?
As Tom pointed out, f1's not in scope for the HAVING clause. If you're
that concerned
On Wed, May 7, 2008 at 4:02 PM, John Smith [EMAIL PROTECTED] wrote:
Does anyone see a problem with this approach (e.g., correctness,
performance, etc.)? Or is there perhaps an alternative approach using
some other postgresql mechanism that I'm not aware of?
Did you already look at and
On Wed, May 7, 2008 at 7:06 PM, Toby Chavez [EMAIL PROTECTED] wrote:
My custom type needs to have one biginteger and one text value... pretty
straight forward. I guess my first question is if there are any examples out
there that do something similar. I have looked extensively through the
select class, size from X t1 where size in (select size from X t2
where t2.class=t1.class order by size desc limit 5);
On Tue, May 6, 2008 at 1:22 PM, Kynn Jones [EMAIL PROTECTED] wrote:
Suppose table X has two columns: class (TEXT) and size (INT). I want a
listing showing the (up to) 5
Maybe I'm some crazy, radical DBA, but I've never had a version of
pgsql get EOLed out from underneath me. I migrated from 7.4 to 8.1
right around the time 8.2 came out then upgraded to 8.2 around 6
months later.
Where I work now we are looking at migrating from 8.1 to 8.2 or 8.3
Thanks for the help from everyone on this. Further investigation with
the suggested statistics and correlating that with some IO graphs
pretty much nailed the problem down to checkpoint IO holding things
up, and tuning the checkpoint segments and completion target (128 and
0.9 seemed to be the
On Tue, Apr 22, 2008 at 9:52 AM, Joris Dobbelsteen
[EMAIL PROTECTED] wrote:
Describe the mechanism, because I don't really believe it yet. I think you
need to do a advisory lock around every commit of every transaction that
writes to the log table.
Consider some number of reader processes
On Tue, Apr 22, 2008 at 2:48 PM, Joris Dobbelsteen
[EMAIL PROTECTED] wrote:
Ah, yes, all visible rows...
My point is that, unless you use a transaction with serializable isolation,
this all visible rows for the second statement might be different from those
that you copied into the log
I have a fairly simple table (a dozen real/integer columns, a few
indexes, one foreign key reference) with ~120m rows. Periodically the
table is truncated or dropped and recreated and the data is
regenerated (slightly different data, of course, or the exercise would
be rather pointless). The
On Tue, Apr 22, 2008 at 4:38 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
The best bet is to issue an analyze table (with your table name in
there, of course) and see if that helps. Quite often the real issue
is that pgsql is using a method to insert rows when you have 10million
of them
On Tue, Apr 22, 2008 at 5:04 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
Normally, after the first 50,000 or so the plan won't likely change
due to a new analyze, so you could probably just analyze after 50k or
so and get the same performance. If the problem is a bad plan for the
inserts /
On Tue, Apr 22, 2008 at 5:18 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
Try upping your checkpoint segments. Some folks find fairly large
numbers like 50 to 100 to be helpful. Each segment = 16Megs, so be
sure not to run your system out of drive space while increasing it.
Ahh, much more
On Tue, Apr 22, 2008 at 6:10 PM, Tom Lane [EMAIL PROTECTED] wrote:
David Wilson [EMAIL PROTECTED] writes:
Are you loading any tables that are the targets of foreign key
references from other tables being loaded? If so, I'd bet on
Scott's theory being correct with respect to the plans
On Tue, Apr 22, 2008 at 7:33 PM, Tom Lane [EMAIL PROTECTED] wrote:
What have you got shared_buffers set to? If it's not enough to cover
the working set for your indexes, that might be the (other) problem.
shared_buffers = 1536MB
Is there a way to get the size of a specific index, on that
On Mon, Apr 21, 2008 at 7:55 PM, Joris Dobbelsteen
[EMAIL PROTECTED] wrote:
If you want to clean up the the staging table I have some concerns about
the advisory lock. I think you mean exclusive table lock.
Either works, really. An advisory lock is really just a lock over
which you have
On Thu, Apr 17, 2008 at 1:55 PM, Roberts, Jon [EMAIL PROTECTED] wrote:
Using the term metadata is misleading in your example. Metadata is
data about data and in your example, you just have data. It is fine to
join tables in an RDBMS.
I believe you missed the OP's actual goal. He's not
(I originally missed replying to all here; sorry about the duplicate,
Vance, but figured others might be interested.
On Wed, Apr 16, 2008 at 1:55 PM, Vance Maverick [EMAIL PROTECTED] wrote:
Another approach would be to queue the log entries in a staging table,
so that a single process could
On Mon, Apr 14, 2008 at 1:34 PM, Chris Browne [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] [EMAIL PROTECTED] writes:
Another test. In postgres I added an index to the userid column and
then counted distinct userids. The average run time over three
queries was 4666 seconds, or 78 minutes.
On Wed, Apr 9, 2008 at 3:29 AM, [EMAIL PROTECTED] wrote:
But if i do VACUUM ANALYZE without concurrent queries, everything runs fine
afterwards.
If i run VACUUM ANALYZE with few concurrent queries, it slows down to a
crawl.
Could it be that something like this is happening:
- In
On Mon, Apr 7, 2008 at 9:11 PM, Stephen Denne
[EMAIL PROTECTED] wrote:
You may be able to make use of an index by rearranging your query to
generate a series between your min max values, testing whether each value
is in your table.
You've got 4252 distinct values, but what is the range
On Mon, Apr 7, 2008 at 2:05 AM, Alban Hertroys
[EMAIL PROTECTED] wrote:
On Apr 7, 2008, at 1:32 AM, David Wilson wrote:
The databases estimates seem consistent with yours, so why is it doing
this? Could you provide an EXPLAIN ANALYSE? It shows the actual numbers next
to the estimates
On Mon, Apr 7, 2008 at 1:42 PM, Alban Hertroys
[EMAIL PROTECTED] wrote:
Have you tried this query with enable_seqscan=off? If my guess is right
(and the planners, in that case) it'd be even slower.
set enable_seqscan=off;
explain select distinct datestamp from vals;
On Mon, Apr 7, 2008 at 7:57 PM, Gregory Stark [EMAIL PROTECTED] wrote:
You could try changing it to the equivalent GROUP BY query. The planner,
unfortunately, doesn't know they're equivalent and has two separate sets of
plans available. In this case where there are only 4,000 distinct
I have a reasonably large table (~75m rows,~18gb) called vals. It
includes an integer datestamp column with approximately 4000 unique
entries across the rows; there is a normal btree index on the
datestamp column. When I attempt something like select distinct
datestamp from vals, however, explain
in the
vals table is a large (~98%) subset of the set of datestamps in the
sdays table. Of the approximately 4000 distinct datestamps, there are
80 that appear in the sdays table and not in the vals table.
On Sun, Apr 6, 2008 at 10:20 PM, Craig Ringer
[EMAIL PROTECTED] wrote:
David Wilson wrote
76 matches
Mail list logo
